Friday, April 20, 2007

How to reassign the DTS package owner

In most cases, it doesn't really matter who owns the package - who is

executing it is more important. However, there is an undocumented

stored procedure called msdb..sp_reassign_dtspackageowner, which you

can use.

powered by performancing firefox

Thursday, April 19, 2007

SQL Server 2005 - Troubleshooting

PERFORMANCE Troubleshooting Performance Problems in SQL Server 2005 Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005 SQL Server 2005 Waits and Queues

DEADLOCKS Troubleshooting deadlocks in SQL2005

CONNECTIVITY SQL Server 2005 Connectivity Issue Troubleshoot - Part I Troubleshoot Connectivity Issue in SQL Server 2005 - Part II Troubleshoot Connectivity Issue in SQL Server 2005 - Part III Understanding Kerberos and NTLM authentication in SQL Server Connections

START UP FAILURE Error Messages of SQL Server 2005 Start Up Failure

DATA RECOVERY Emergency mode repair DBCC CHECKDB Series

INDEXES New Tools to Diagnose Index Health Rebuilding Indexes, Disk Queue Length, and More

FRAGMENTATION DBCC SHOWCONTIG Improvements in SQL Server 2005 and comparisons to SQL Server 2000

TRANSACTION LOG;EN-US;873235 How to stop the transaction log of a SQL Server database from growing unexpectedly;EN-US;317375 A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server

MEMORY PRESSURE;EN-US;309256 How to troubleshoot SQL Server error 8645;EN-US;907877 How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005

TEMPDB Working with tempdb in SQL Server 2005 TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild

SQLOS - SCHEDULING How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888

BOOKS ONLINE LINKS Troubleshooting the Database Engine Troubleshooting Integration Services Troubleshooting Reporting Services

TOOLS Link para efectuar uma pesquisa através do nos Books Online SQLdiag Utility SQL Server 2005 Performance Dashboard Reports

Nota: Para utilizar esta nova ferramenta é necessário ter previamente instalado no servidor e no cliente o SQL Server 2005 SP2. SQL Server 2005 Best Practices Analyzer (CTP de Fevereiro 2007) SQL Server Profiler + System Performance Monitor Exemplo de um custom Report – TASKPAD view Events and Errors Message Center SQL Server Best Practices


Troubleshooting and Performance Tuning

TechNet Webcast: A SQL Server DBA’s Guide to CLR Integration (Level 300)

TechNet Webcast: Performance Diagnosis in SQL Server 2005 (Level 300)

TechNet Webcast: SQL Server 2005 Database Tuning Advisor (Level 300)

TechNet Webcast: SQL Server 2005 Troubleshooting: Supportability Features for SQL 2005 (Level 300)

TechNet Webcast: Troubleshooting Performance Problems in Microsoft SQL Server 2005 (Level 200)

TechNet Webcast: Troubleshooting SQL Server 2005 Integration Services (Level 300)


Online Indexing Operation in SQL Server 2005

Physical Database Storage Design

Database Mirroring Best Practices and Performance Considerations

SQL Server I/O Basics, Chapter 2 White Papers General