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 |
|
navipro
Starting Member
5 Posts |
 Posted - 2010-04-30 : 15:49:16
|
| Hello,I would like to record how many waiting tasks there are in the database every 3 seconds. I would like to run this job for maybe a day and then have the better understanding of the database load and what are the peak periods and how bad the situation is. I was using before the SQL management Studio 2008 and it has a very nice graph that shows how many tasks were waiting. But the graph goes back only for 3-4 minutes. I would like to have the day's picture.Also is there an ability to add who is in the head of blocking chain?Thanks in advance. Oleg |
|
|
navipro
Starting Member
5 Posts |
Posted - 2010-05-04 : 16:09:17
|
| Well, I kinda solved part of this problem. I used Profiler on the server to get the number of locks and wait time.The only issue taht is left is head of blocking chain.I have also found that you can set the custom query and return the value through profiler - it is called SQLServer:User Settable. There u can select which query to use (1-10). But I am not sure where to specify the query and how to write a query to get the head of blocking chain. |
 |
|
|
Brink
Starting Member
2 Posts |
Posted - 2011-05-16 : 06:00:52
|
| I have the same problem. how can I get nice-graph from sql 2008 activity monitor that contains one day's waiting tasks information.sql/oracle DBA |
|
|
|
Brink
Starting Member
2 Posts |
Posted - 2011-05-16 : 22:33:02
|
| anyone know this?sql/oracle DBA |
|
|
|
chris2011
Starting Member
1 Post |
Posted - 2011-05-17 : 06:26:15
|
| Hi friendServers are often dedicated, meaning that they perform no other tasks besides their server tasks. On multiprocessing operating systems, however, a single computer can execute several programs at once. A server in this case could refer to the program that is managing resources rather than the entire computer.http://www.servercircle.comchris2011 |
|
|
|
|
|
|
Record SQL Server Waiting Tasks