Tag Archives: sql server 2008

Common SQL Server Performance Counters

Somebody asked me what are the common SQL Server Performance Counters to monitor for bottlenecks and unusual activity on the server. The list of common SQL Server Performance counters is as below: SQLServer:Access Methods – Full Scans / Sec SQLServer:Access … Continue reading

Posted in SQL Server | Tagged , , | Leave a comment

T-SQL script to list Page Verify Option of all user Databases in sql server 2008/2005

— Script to list All user databases and their page verify option set. SELECT  name AS [Database] , CASE WHEN page_verify_option = 0 THEN ‘NONE’ WHEN page_verify_option = 1 THEN ‘TORN_PAGE_DETECTION’ WHEN page_verify_option = 2 THEN ‘CHECKSUM’ END AS [Page Verify] … Continue reading

Posted in SQL Server, T-SQL Scripts | Tagged , , , , | Leave a comment

Failed to decrypt protected XML node “DTS:Property” with error 0x8009000B “Key not valid for use in specified state.”

TITLE: Microsoft Visual Studio ——————————————— There were errors while the package was being loaded. The package might be corrupted. See the Error List for details. ——————————————— BUTTONS: OK ——————————————— Error    1    Error loading xyz.dtsx: Failed to decrypt protected XML node … Continue reading

Posted in SQL Server, SSIS, Troubleshooting | Tagged , , , , | 4 Comments