long running query/bad sql - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Administration (2000)

long running query/bad sql

Author

Topic

saurabh811
Starting Member

33 Posts

Posted - 2008-05-28 : 14:50:19

hi everyone,

database: sql server 2000
OS : windows 2003 server

how to find out find bad sql that cost time to application.
my end user try to pull records and its only 3 to 4 records but still it will take more then 20 sec.so can any one tell me hoe to find out that query that cost more time then expected.

thanks in advance..pls help me its urgent
saurabh

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-28 : 14:52:43

Just check out the execution plan of the query.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-28 : 14:52:47

check execution plan of the Query with actual execution plan whether you are not using any index.

saurabh811
Starting Member

33 Posts

Posted - 2008-05-28 : 15:13:42

i knw about execution plan.but how do you find out that query?? is there any way u can find out bad sql in a current session??
exe. top five query??? like in oracle u can find out using v$sql..so there any view in sql server 2000??
if u knw pls let me knw...thks..

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-28 : 15:15:46

Run SQL Profiler to determine what queries are performing poorly.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-28 : 15:20:27

Check out standard Reports that comes with SQL server in right side.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-28 : 15:25:12

This thread was posted in the SQL Server 2000 forum, so if 2000 is being used then those reports are not available.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-28 : 15:25:42

Sorry it doesn't come with SQL 2000. You have to go with Profiler as Tara suggested.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources