SQLRx Tip of the Month: New Dynamic Management View

SQLRx^® Tip of the Month

January 2013

SQL Server Administration: (SQL 2008 R2 and SQL 2012) Use the new dynamic management view sys.dm_server_services to see information about SQL Server services such as when service last started, running status, service account, etc... For more information, check out Books Online or http://msdn.microsoft.com/en-us/library/hh204542.aspx

TOM Jan13

_______________________________________________________________________________

As always, don't forget to regularly monitor the 11 VitalSigns used by SQLRx to debug performance bottlenecks.

If you have a SQL question you'd like us to answer, and possibly use for the next SQLRx Tip of the Month, email it to us! If you missed any of our previous tips, you can view them here.

For assistance or more information on optimizing your SQL Server Environment, visit us at www.sqlrx.com or email Lori Brown at lorib@isi85.com.

Sincerely,

Lori Brown | SQLRx Senior Consultant | Integrated Services, Inc.
4144 N. Central Expwy, Suite 430 | Dallas, TX 75204
Phone: 214.526.7680 x 113 | lorib@isi85.com

http://blog.sqlrx.com/

Integrated Services, Inc.

Turning Data Into Profit

25 Years of Credibility & Trust

Join our email list Check out our events SQLRx Downloads