Archive for February, 2010

New Documentation and Training Content for Foglight Performance Analysis for SQL Server

Posted 2/4/2010 at 6:11 PM by Ari Weil

Product documentation and product training are two areas where you (our customers) consistently press us to improve…and we have.

If you navigate to www.quest.com/foglight-performance-analysis-for-sql-server and click on Key Product Documents you’ll be taken to a page that lists all the documents you should need to get you from initial evaluation, to the demo/POC phase, and through implementation and use case training.

Also, a little while back we introduced some new micro workshops so you can get help with things like sizing your environment prior to installation, and with training on using Performance Analysis effectively once it’s installed without breaking the bank. Just navigate to www.quest.com/foglight-performance-analysis-for-sql-server and you’ll see a link to Find out about Technical Training.

Easy, right?  Want more?  We’re happy to help.  Contact your account representative, your favorite Quest SQL Server contact, or participate in one of the forum discussions and ask.

Compressing SharePoint Backups with LiteSpeed FastCompression

Posted 2/4/2010 at 10:35 AM by Brent Ozar

Microsoft SharePoint content databases are notoriously difficult to compress.  Users upload Word documents, Excel spreadsheets, and PowerPoint presentations into the SharePoint sites, and these bulky files go straight into the SQL Server database.  They’re tough to compress, and the files just keep piling up as more users start using the company intranet.

Even worse, us database administrators are told that SharePoint is now mission-critical, and we have to make sure we back it up as fast and as often as possible.  How do we do it?  In this five-minute video, Brent Ozar shows how to use LiteSpeed’s new FastCompression to pull it off.

Get the Flash Player to see the wordTube Media Player.

LiteSpeed for SQL Server – Enable Logging

Posted 2/1/2010 at 3:33 PM by Andy Grant

When an issue occurs during your backup and recovery process such as performance spikes, it is extremely beneficial to get as clear a picture as possible of what activities are occurring in your SQL Server environment.  LiteSpeed for SQL Server offers this clarity by logging these activities for immediate analysis and isolation of any bottlenecks.  This video takes you through the process of enabling logging through the LiteSpeed for SQL Server console and will cover four different areas within the product.

  • Backup Wizard
  • Restore Wizard
  • Maintanance Plans
  • Console Logging

Special thanks to April Bucher on the LiteSpeed QA team for putting this short video together. 

Get the Flash Player to see the wordTube Media Player.