• Beach Tweets

  • Archives

  • RSS PEER 1 Blog

    • An error has occurred; the feed is probably down. Try again later.

Resolve SQL Server Performance Issues with Spotlight

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.

2 Responses

  1. what does SQL server does
    i see it is somehow related to web design

  2. Can Spot light do everything what IDERA SQL SECURE TOOL can do?

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: