Now that I've got things working..... 2

[gbaughma]

... in my SQL Server 2008, it's time to fine-tune things a little.

Where do I find the Index Tuning Wizard (or query analyzer, or whatever tool looks at my stored procedures and makes recommendations for indexes) in SSMS 2008?

TIA!

Happy Monday!


Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[RiverGuy]

In the Query menu, there is an option called "Analyze Query in Database Engine Tuning Advisor."

It should also be under SQL 2008 and under Performance Tools in your Start menu.

 

[gbaughma]

Hmmm... I must not have installed that... I don't see performance tools.

I'll take a look on the installation CD.



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[gmmastros]

I think that the Database Engine Tuning Adviser is not available with SQL Express. Is that what you are using?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gmmastros]

More specifically... when you install SQL Server Management Studio Express, it probably does not install the Database Engine Tuning Adviser. Also... if you are using a higher level of SQL Server Management Studio, and trying to tune a DB that is attached to an express instance, you will get an error message:

[!][tt]Database Engine Tuning Advisor does not support SQL Express (DTAClient)[/tt][/!]

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gbaughma]

I'm running SQL Server 2008 (not express).

I did find the activity monitor, which does a "Show Execution Plan", which I can then look at and see what's going slowly.

I wish I had a better understanding of it... it's one table that is slowing things down, and I think it's because I need to add an index....

I'll keep googling for the Execution Plan information and how to interpret the information.



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[gmmastros]

I may be able to help. Try this:

Set ShowPlan_Text ON
go
-- Your code here
go
Set ShowPlan_Text OFF

When you run the code, you will set the execution plan shown in the results window.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gbaughma]

Mmm... I think I found my slow issue. The whole script is taking about 5 seconds to run now (very acceptable... keeping in mind, the queries are running in milliseconds now, but the ASP script that calls them is 1500+ lines... so 5 seconds to build a 4-sheet Excel workbook dynamically is not bad.)

I forgot to make a primary key for my 1.6M record "Results" table. (Blush)

Funny how much faster that made it....



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[gmmastros]

Greg,

I would be very interested in having a private conversation with you. I just sent you feedback on your personal website. If you have the time and the inclination, please check your feedback and send me an email.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gbaughma]

Hi George. I won't be able to check my parallel account until I get home... however if you want to send me an email to my handle at gmail, I will get that immediately on my phone.



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com