Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 query slowness

Author  Topic 

nextaxtion
Yak Posting Veteran

54 Posts

Posted - 2014-02-24 : 04:21:55

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 - 2014-02-24 : 04:50:20
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
   

- Advertisement -