Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Having 'black-box' recorder for SQL Server!

Say you have a serious performance problem and few times you will have assertion issue with a dump files creation, in real world say this can be matched to a airplane crash. Where you will know the sequence of events from Black-box records in the flight to investigate, similarly how about having such facility for SQL Server to monitor the sequence of events with a user ran a query against your SQL Server and crashed it or made the server unusable since the CPU was spiked at 100% all the times!

A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors. You can use this information to determine why your server crashed or what error occured right before your CPU was pegged.

Paul Randal highlighted having such black-box related facility within your 'SQL Server' environment,  more from Paul's Blog.

Posted: Monday, July 02, 2007 1:34 AM by SQL Master

Comments

SSQA - SqlServer-QA.net said:

Say you have a serious performance problem and few times you will have assertion issue with a dump files

# July 2, 2007 1:38 AM

SQL Server Security, Performance & Tuning (SSQA.net) said:

Yet another important factors that every DBA needs to concerned about table & index fragmentation

# July 31, 2007 8:03 AM
Anonymous comments are disabled