Sound familiar?

“The SQL Server was performing great yesterday and all of a sudden today the performance is terrible.”

Foglight Performance Analysis has a very powerful feature that allows you compare two different properties of your SQL Server workload.  This scenarios could be:

• Comparing the performance of a database over two different time ranges. 
• Comparing the performance of a single stored procedure over two different time ranges.
• Comparing the performance of database A to database B over the same time range.
• etc…

Take a look at this short tutorial and see how the feature could help you in your environment!  Any questions, feel free to comment.

Hello all, we get questions from time to time asking how alarms in Spotlight on SQL Server Enterprise can be configured to match a specific customers need.  Questions such as:

1) As a database administrator, all of my critical data files are on my F and G drives.  I don’t want to monitor those drives with the same thresholds and alerts as I do my C drive.

2) I have different backup policies for different databases on my servers and I don’t want to alarm on every database the same way.

All of these use cases can be met with Spotlight on SQL Server Enterprise’s alarm configurations.  Please watch the video below to see how its done.  If anyone has any questions or comments, or you want to be walked through a use case of your own, leave a comment or post in the forums!

Quest’s Benchmark Factory load tests your stored procedures and your database server to find out how many users you can support.  Learn how to set up a stored procedure load test in this 8-minute video.

Some SQL Server instances are set up with the username SA and a blank password.  In other shops, previous DBAs used easy-to-guess back door accounts to make management easier.  To secure your environment, you can use Quest’s free Discovery Wizard to look for common usernames and passwords.  In this short video, we show you how to get started.

How many SQL Servers are in your datacenter?  Find out fast with Quest’s free Discovery Wizard.  In this short video, we show you how to get started.

Keep track of your ever-changing SQL Server inventory with Quest’s free Discovery Wizard.  In this short video, we show how to set a baseline and find out when servers have been added, removed or changed.

Quest’s free Discovery Wizard tool helps you discover and report on your SQL Server instances.  One of the things it checks is for the installed version of Quest LiteSpeed for SQL Server.  If you need to find out where LiteSpeed is installed, watch this short tutorial video to learn how.

Need to recover just one table?  Or maybe someone dropped a stored procedure?

LiteSpeed’s Object Level Recovery helps you restore individual objects from a SQL Server backup – either native or LiteSpeed.  Brent Ozar shows how in this short video.

LiteSpeed’s built-in wizards make it easy to restore a database.  No matter what combination of full backups, differential backups, and transaction log backups are involved, it’s point-and-click easy.  LiteSpeed even generates the right combination of RESTORE DATABASE scripts.  Brent Ozar shows how in this short video.