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.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-09-24 : 07:00:13
|
| Hello ,I want to draw an outline in the DTS which can show the performance of one of our SQL 6.5 servers which has been running extremely slow recently . Is there any way to draw a map of the server with the clients connected which can display the amount of time taken by a specific query to execute with CPU time , physical reads and writes or any in other was which can tell us how to determine and anlyse this problem ?? Any info. in this regard ? Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-24 : 07:08:16
|
| You can take a snapshot of sysprocesses which will show how long things are taking.If you log things to a table every 30 secs or so you will get a good idea of what is going on.You can use dbcc inputbuffer to find the command that is being executed but taking a dump of the locks usually gives a good idea.see www.nigelrivett.comsp_nrLocksfor some ideas on what to log and how to do it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2002-09-24 : 07:50:06
|
| Hello NR,Thanks for your information and help . Further , can we have an execution plan enabled in SQL 6.5 as we have it in SQL 7.0 and SQL 2000 . I.e when we execute a query and if we enable ' show execution plan 'then it creates a map and shows the vital statistics .If that is available on SQL 6.5 then i am missing that tool . How can i have it installed on my SQL 6.5 server ??Thanks once again . |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-24 : 08:21:59
|
| Yes it is available with v6.5 but you don't get pretty pictures.Can't remember what it is but maybe an option for show statistics?I think there's one for the actual statistics and another for an estimated plan for use with no exec.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Performance of SQL Server 6.5 .