rodynetwork
asked on
SQL query time
We have a custom app written in ASP.NET 3.5 and C+ that we interface via Internet Explorer on our desktops. It uses a SQL database on our SBS 2008. Some of the queries take 30-60 seconds and I would like to speed that up. One option I am looking at is to change over to a SSD on on the server, as I feel the RAID 5 is contributing to the slowness. Any SQL experts want to give input on what I should look at, whether to upgrade to an SSD or whether to have a look at the SQL code?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually, what I may do is set up a second SBS 2008 and practice on it. Do you think it is realistic to get input from EE experts for that? I am thinking of setting up the second server and learning by doing. I figure I can use Go to Meeting for allowing experts to show me things that are difficult to convey in posts.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the tip. Where is the tuning advisor located?
ASKER
In SSMS, under tools, I am finding "external tools, customize, options". I don't see Tuning Advisor in any of those. Where do I find it?
In SSMS, it's under Tools --> Database Engine Tuning Advisor. But when you run it, you need a query or stored procedure to tune. You can also find it if you right click on the query window.
Greg
Greg
>>I don't see Tuning Advisor in any of those. Where do I find it? <<
What Edition do you have?
SELECT SERVERPROPERTY('Edition')
What Edition do you have?
SELECT SERVERPROPERTY('Edition')
ASKER
>>I can't find "server properties".<<
1. Click on the big button on the top left corner that reads "New Query".
2. Type in the new window: SELECT SERVERPROPERTY('Edition')
3. Press F5
4. Post the output.
>>Sorry, I am almost completely ignorant at this point with SQL. <<
It may be time to crack some books, so that you can at least get the basics.
1. Click on the big button on the top left corner that reads "New Query".
2. Type in the new window: SELECT SERVERPROPERTY('Edition')
3. Press F5
4. Post the output.
>>Sorry, I am almost completely ignorant at this point with SQL. <<
It may be time to crack some books, so that you can at least get the basics.
ASKER
what books do you recommend? Or, can you recommend a starting point? It is hard to know where to start....
ASKER
cool. Standard Edition (64 bit)
>>what books do you recommend?<<
I would go on Amazon and find an entry level book on the subject. You also have SQL Server BOL available to you.
I would go on Amazon and find an entry level book on the subject. You also have SQL Server BOL available to you.
While you have the query window open, you should find the "Database Engine Tuning Advisor" under "SQL Server Profiler" in the Tools menu.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I haven't been able to find Tuning Advisor. I am closing this post because I think before I go any further, I am going to set up a second server from an image of this one and practice. I am concerned I may break something on our live server....thanks for the input, guys!
ASKER