One of my friend recently asked me a question, How to view the list of features installed in the SQL Server easily without going through “Programs and Features” or “Services”.
Yes, there is an easy way
SQL Server 2008 / 2008 R2 / Denali provides “Installation Center” using which we can view features of all locally installed SQL Server versions 2000 / 2005 / 2008 / 2008 R2 / Denali including the SQL Express editions
Please follow the below steps to do that
1. Click on “Start” –> “All Programs” –> “Microsoft SQL Server 2008 R2” –> “Configuration Tools” –> “SQL Server Installation Center
2. Click on “Tools”
3. Click on “Installed SQL Server features discovery report”
The following report will be generated and opened in your browser.
The report displays the SQL Server version Name, Instance Name and its ID, Feature Name, Installed Language ID, SQL Server Edition, Version Number and whether its clustered or not.
Output from SQL Server “Denali”
I hope you all find this useful…
SQL Diag Configuration Tools is an easy to use tool which will help you in configuring SQLDiag.xml to collect performance data from SQL Server 2005/2008/2008 R2
SQL Diag Configuration Tool is a free tool available on Codeplex. You can download it from the following link
Let us walkthrough the steps of using SQL Diag Configuration Tool
After installation, run the tool
Select your desired SQL Server version and then click on “Authentication Method” option available on left side
Specify the Server name and SQL Server Instance Name on which you are planning to use the SQLDiag.xml and then click “Machine Wide Diagnostics” option
Select the Events Logs you want collect as part of performance data and then click on “Instance Specific Diagnostics”
If you want to collect Blocking information, select “Blocking” and the specify the Maximum File Size of log and the maximum number of files and the polling interval on which the Blocking information should be collected from SQL Server
Next Click on “Profiler" Options
Click “Enable SQL Tracing” to collect Profiler information and select a Trace Template.
Available Trace Templates are
After selecting, you can also add further Events you want to collect and then specify the maximum file size, maximum number of files and polling interval on which profiler information should be collected from SQL Server
Next click “Perfmon Options” to proceed
Select the Performance Counters which you want to collect or select the predefined template available and then specify Maximum File Size and the polling interval on which performance counter data should be collected
Next Click on “Producers” to enable the Producers options
Next Click on the “Analyzers” to enable the required Analyzers
Click “Save” to SQLDiag1050.xml and use it as input for SQLDiag to collect SQL Server Performance Data
You can use the “Open” option reload the saved SQLDiag xml file and modify the profiler or perfmon or other above specified options.
I hope you find this useful…