|
Home > Archive > MS SQL Server > November 2006 > How do you get the current load status of the server?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How do you get the current load status of the server?
|
|
| Brennan Stehling 2006-11-09, 7:14 pm |
| I am working in an environment with a test database server which holds
all of the databases used here. When someone is pulling down a lot of
data from the Production server, it causes the server to become fairly
unresponsive. I would like to be able to notify myself when the load
is high so I can divert my focus to something other than refining
queries. It is just hard to tune the performance of a query when
someone else is pounding the database, so it throws off my
measurements.
So how can I gather metrics on the server load? I would like to simply
query the database, but I suppose I can also install a service on the
machine to tell me the CPU load as well.
Any suggestions?
Brennan
| |
| Hilary Cotter 2006-11-10, 12:12 am |
| What about running performance monitor to collect cpu info.
You can also issue queries like this every minute and collect the info into
a table.
SELECT TOP 20 * from master..sysprocesses
ORDER BY cpu DESCThen build alerting off this is a spid has sustained high
cpu.--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Brennan Stehling" <offwhite@gmail.com> wrote in message
news:1163105973.475971.80330@h48g2000cwc.googlegroups.com...
>I am working in an environment with a test database server which holds
> all of the databases used here. When someone is pulling down a lot of
> data from the Production server, it causes the server to become fairly
> unresponsive. I would like to be able to notify myself when the load
> is high so I can divert my focus to something other than refining
> queries. It is just hard to tune the performance of a query when
> someone else is pounding the database, so it throws off my
> measurements.
>
> So how can I gather metrics on the server load? I would like to simply
> query the database, but I suppose I can also install a service on the
> machine to tell me the CPU load as well.
>
> Any suggestions?
>
> Brennan
>
|
|
|
|
|