• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

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?
0
rodynetwork
Asked:
rodynetwork
  • 9
  • 5
  • 2
  • +2
4 Solutions
 
tim_csCommented:
Have you looked at the indexes that have been created or do indexes exist?  
0
 
JestersGrindCommented:
Run the suspect queries in SSMS with Include Actual Execution Plan turned on.  In 2008, the execution plan will actually recommend missing indexes if it thinks that some are needed.  If there are no missing indexes, do you rebuild your indexes on a regular basis?  Rebuilding indexes will defrag your data and more importantly update your statistics which is what SQL Server uses to determine the best execution plan.

Greg

0
 
rodynetworkAuthor Commented:
I know nothing about SQL, but I want to learn.  Can you walk me through how to run the queries in SSMS with Include Actual Execution Plan?  I have SSMS up and have the Object Explorer-server expanded.
0
Protect Your Employees from Wi-Fi Threats

As Wi-Fi growth and popularity continues to climb, not everyone understands the risks that come with connecting to public Wi-Fi or even offering Wi-Fi to employees, visitors and guests. Download the resource kit to make sure your safe wherever business takes you!

 
rodynetworkAuthor Commented:
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.
0
 
Ramesh Babu VavillaCommented:
use SQL Server tunning advisor to take  advice , where to create a index to improve the performance
0
 
rodynetworkAuthor Commented:
Thanks for the tip.  Where is the tuning advisor located?
0
 
rodynetworkAuthor Commented:
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?
0
 
JestersGrindCommented:
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

0
 
Anthony PerkinsCommented:
>>I don't see Tuning Advisor in any of those.  Where do I find it? <<
What Edition do you have?

SELECT SERVERPROPERTY('Edition')
0
 
rodynetworkAuthor Commented:
I can't find "server properties".  I attached a pic. Does that help?  Sorry, I am almost completely ignorant at this point with SQL.     1
0
 
Anthony PerkinsCommented:
>>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.
0
 
rodynetworkAuthor Commented:
what books do you recommend? Or, can you recommend a starting point?  It is hard to know where to start....
0
 
rodynetworkAuthor Commented:
cool.   Standard Edition (64 bit)
0
 
Anthony PerkinsCommented:
>>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.
0
 
Anthony PerkinsCommented:
While you have the query window open, you should find the "Database Engine Tuning Advisor" under "SQL Server Profiler" in the Tools menu.
0
 
rodynetworkAuthor Commented:
Sorry, I feel an idiot, so posting a pic. Can't find that anywhere.... 2 2
0
 
Anthony PerkinsCommented:
I have no idea why you do not have it available.  I thought even the Standard Edition supported it.  I suspect you do not have the appropriate permissions.  Apparently you have to have the sysadmin server role the first time you start it.  After it has been initialized, then db_owner database role is all that is required.  But here is a tutorial on how to use it:
http://msdn.microsoft.com/en-us/library/ms166575(v=SQL.90).aspx
0
 
rodynetworkAuthor Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 9
  • 5
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now