Charnell Lucich

SQL Enterprise Server Issues? Discover, Diagnose, and Resolve them with Spotlight

Posted on: December 13, 2007

I read a really great HowTo written by Joshua Hoskins this morning for Spotlight on SQL Server from Quest Software .

Spotlight is a tool to help SQL Server Database Administrator’s monitor the performance of their Microsoft SQL Servers, and be alerted when there are problems. It provides valuable information in an easily accessible format.

“This not only provides the data about operations going on in your SQL environment such as your cache hit ratio, and pages in memory, but also operating system level information such as disk queue length, page file usage, and all process running on the system, not just SQL processes.

This full featured program can monitor multiple SQL instances simultaneously (multiple simultaneous monitoring is only available in Enterprise edition) without the need to install software on your SQL Servers, though you will need a SQL Server to house your work databases.”

Read Joshua Hoskins’ HowTo here.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Follow Charnell Lucich on WordPress.com

Follow me on Twitter

%d bloggers like this: