Tag: performance

SQL Server 2012 Performance Dashboard Report

Performance dashboard is developed for SQL Server 2005 which provides useful information about the server, in simple it will give you an performance overview of entire SQL Server. If you worked with SQL Server 2005 then you might be familiar with this tool. Unfortunately they didn’t provide or updated the tool to work with SQL… Continue reading SQL Server 2012 Performance Dashboard Report

Performance View on INNER JOIN and OUTER JOIN

Hope you guys are getting ready for Diwali Festival :-). Before you guys start with the festival event I thought of writing an article on performance.  Couple of days ago one of the developer came to me and said he was using  an INNER join in his query and he is getting delay in results,… Continue reading Performance View on INNER JOIN and OUTER JOIN

What’s new in DTA – SQL Server 2012

DTA stands for Database Tuning Advisor which has introduced from SQL Server 2005. This utility helps the end user to tune their query and give them suggestions for better performance. It takes T-SQL query or profiler trace as workload, based on this it will analyze and give you the recommendation. Now in SQL Server 2012… Continue reading What’s new in DTA – SQL Server 2012

Day 12–Trace Flag 1222–Capture Deadlock information in XML like format

Yesterday we saw the trace flag 1204 which will give you the information based on nodes. Today we are going to get similar deadlock information using trace flag 1222 in XML like format which means the format does not conform to an XML Schema Definition (XSD) schema. After you enable the trace flag when an… Continue reading Day 12–Trace Flag 1222–Capture Deadlock information in XML like format