SQL Server Denali has introduced lot of DMV’s and DMF for HARDON. Here is a list of DMVs and DMF which are being used by HARDON / Availability Groups. The System View MAP for all DMV and DMF for SQL Server Denali CTP1 HARDON, as on date. This system view was being built by One [...]
Category Archives: Troubleshooting
SQL Server DENALI HARDON DMVs and Functions – SYSTEM View MAP
Posted by Mahesh Gupta on December 15, 2010
3 comments
DBCC TRACEON – Follow-up
Posted by Mahesh Gupta on October 29, 2010
0 comments
In my recent post on using DBCC TRACEON() in conjunction with setting startup parameters, I pointed out that you can frequently avoid the need to restart a SQL Server immediately by specifying the startup flag/parameter necessary and then just executing…
How to identify your SQL Server version and edition even if SQL Services are not running
Posted by Mahesh Gupta on August 2, 2010
1 comment
I was being called in a mid of a upgrade project from SQL Server 2005 to SQL Server 2008. The assigned DBA resource has gathered all the information related to SQL Server. SQL Services were stooped so that cold backup of files can be performed at file level. So SQL services were taken down and [...]
Error 5233 – SQL Server 2008 database
Posted by Mahesh Gupta on June 24, 2010
0 comments
In SQL Server 2008, the Auditing feature has been introduced that allow you to track user and system activity for the enterprise customers. This feature provides the option to detect any unauthorized access attempts, if any, to the SQL Server database. Also, it facilitates a rich and powerful tracking capability to recognize any sensitive configuration [...]
SQL Server properties changed on cluster resource failover
Posted by Mahesh Gupta on June 20, 2010
0 comments
One of my friend has recently had an issue on one of his SQL Server two node cluster. He was seeing different authentication modes for SQL Server depending on which node of the 2-node cluster that it was online on. The only recent change to their SQL Server environment was that they applied Service Pack [...]
SQL Server Performance issues- From where to start in crises
Posted by Mahesh Gupta on June 15, 2010
0 comments
Performance is the area where a operational DBA spends around 40 % of his/her time and out of this 40 %, 70 % time is used to figure out, what is wrong. To reduce this time, here are query handy SQL statements which will give you some startup where you should to deal with performance issues. These are few very basic queries, which [...]
