There's a couple SQL Server monitor scripts over on deadcat.net. Maybe you could modify them to your needs?
Jerald M. Sheets jr.
On Mon, Mar 22, 2010 at 11:50 AM, Ambati Srinivas <am.srini at gmail.com>wrote:
Hi,
I would like to monitor normal MS SQL Parameters listed, running jobs and also locks if any.
AvailabilityBlocked Processes Configuration Status Disk I/O Errors Error Log Updates SQL Agent Job Failures SQL Agent Status SQL Server Status Capacity Connections Remaining DatabaseApp Space Utilization Suspect Database FilegroupApp Space Available Space Used Space Utilization Performance Buffer Cache Hit Ratio CPU Utilization Deadlocks Packet Errors
Thanks much for your assistance. AM
On Mon, Mar 22, 2010 at 9:06 PM, Storer, Raymond <storerr at nibco.com>wrote:
What are you trying to accomplish exactly?
Ray
*From:* Ambati Srinivas [mailto:am.srini at gmail.com] *Sent:* Monday, March 22, 2010 8:25 AM *To:* hobbit at hswn.dk *Subject:* [hobbit] MS SQL Monitoring on Windows 2003 64-bit
Hi Every one,
Does any successfully got MS SQL on Windows 2003 64-bit?
Please help as soon as possible as I am in the verge of tight deadline to deliver for the client.
Detailed steps would be very very very helpful.
Thank,
AM
CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message.