SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 query slowness
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nextaxtion
Starting Member

India
32 Posts

Posted - 02/24/2014 :  04:21:55  Show Profile  Reply with Quote

my query is executng fast yestreday but today it is running slow .please help how to resolve the issue.
what need to check. the query is simple select only

prithvi nath pandey

Robowski
Posting Yak Master

101 Posts

Posted - 02/24/2014 :  04:50:20  Show Profile  Reply with Quote
Try sp_who2 as a start to see if there is anything else going on, blocking, other high performance consuming queries.

Run it with the execution plan...

quote:
Originally posted by nextaxtion


my query is executng fast yestreday but today it is running slow .please help how to resolve the issue.
what need to check. the query is simple select only

prithvi nath pandey

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000