Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The SQL Server Easter Egg

By Steve Jones,

I was testing some of the new features in SQL Server 2008 and discovered an amazing Easter Egg. With Easter coming in a couple weeks, I thought I'd share this fun tidbit in the editorial.

In SQL Server 2008, there is a new feature called the Data Collector. It's a component that reads all types of measurements from your SQL Servers and store them in a database called the Management Data Warehouse. There are also some reports in Management Studio that allow you to track the usage of your SQL Servers over time.

However, check this out:

This report shows static activity from your server, but you can get this to update and show data in real time! And it's only a 1% CPU hit on your server. This is a great little Easter Egg you can sit on a server somewhere to show the boss that you're actively monitoring your SQL Server. You can even edit the RDL to put whatever server name you want on the report. That way you can appear to be monitoring the sales server when it's really loading your local instance.

To enable this Easter Egg, first you need to close Management Studio and then start it from the command line with the -q parameter as :"SQLWB -q". Next choose the Server Activity Report under the Data Collector.  Now press the left ALT key, the left Shift key, the "R", and it's April Fools.

Hope you've enjoyed this short note, no Easter Eggs I'm aware of in SQL Server 2008.

Steve Jones

 
Total article views: 762 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Managing MaxMemory Values on an Active-Active Two Node Cluster

How to manage your MaxMemory values on an Active-Active two node cluster.

ARTICLE

Happy Easter

Happy Easter wishes from SQLServerCentral.

FORUM

How to Access Active Directory with management studio 2008

Active Directory Sql Management studio

FORUM

REPORTING SERVER ON MANAGMENT STUDIO 2005 NOT CONNECTING FOR REMOTE USERS

REPORT SERVER OVER THE MANAGMENT STUDIO 2005

FORUM

Application Server Unavailable error SSRS Report Manager

Application Server Unavailable error when accessing the Report Manager for SQL Server Reporting Serv...

Tags
april fools    
editorial    
humor    
 
Contribute