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

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

Configuration Manager for Sqldiag

SQLdiag is a diagnostics collection utility to collect logs and data files from SQL Server that you can use to monitor your servers over time or troubleshoot specific problems with your servers.  SQLdiag can collect data from: Windows performance logs, Windows event logs, SQL Server Profiler traces, SQL Server blocking information, and SQL Server configuration information.

Until now, there was not a way to customize what data you needed to collect.  But Microsoft has released a tool to allow customization, called Pssdiag and Sqldiag Manager (Pssdiag is the version for SQL Server 7.0/2000).  Additionally, you can use it to collect data for SQL Nexus, which is a data analysis tool used by Microsoft product support (SQL Nexus helps you identify the root cause of SQL Server performance issues – it loads and analyzes performance data collected by SQLdiag).

More info on Pssdiag Manager: Pssdiag/Sqldiag Configuration Manager released to codeplex

More info on SQLDiag: How to use SQLDiag, SQLNexus and PAL tools to analyze performance issues in SQL Server

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.