|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 02/24/2010 : 09:20:54
|
Hi,
I don't know whether this can be achieved or not but this is what am looking for.
Need a script which will monitor the memory usage , cpu utilization of a particular database server.
Basically, i should have a table which contains follow columns
RemoteServerName,
Dbname,
DBSize,
TotalSystemMemory,
MemoryConsumdSoFar,
CPU utilization,
loginname,
date,
time
...
I will be creating this table in a separate machine (local instance).
I will be creating a Linked Server to the Remote Production Server which is in the same domain, i need to HIT the production server every 1 hour between morning 8 AM and 6 PM and collect the statistics and store it in the table.
Basically, i need this is because every end of quater, there will be data submission from different clients and lot data and memory and cpu will be utilized optimally.
For that reason, i want to monitor for this end of the quarter. So that i can collect the statistics for the whole month and through we can predict how mauch is memory usage, db growth and cpu utilization.
Can anyone help me out if such / similar kind of functionality is already done.
Thanks in advance.
|
|
sql server monitoring using sql script
