Symbols and symbol files

Some of us are unaware of the relevance of proper symbols files. The symbol file is a deliverable just like the binary. Though it is not required for running the application, it is very important to debug issues which arise in production.   What are symbols and symbol files? Symbols contain the mapping between the…


Resources from TechEd sessions

Several attendees have asked for the resources section from our presentations at TechEd India. Enjoy! BlogsSQLCAT: WINCAT: Oks’ blog: Product Feedback External Links:NUMA FAQ: Books:Inside Microsoft SQL Server 2005: Query Processing and Optimization (Volume 3)The Guru’s Guide to SQL Server Architecture and Internals (SQL Server 2000) SQL Server 2005 – Operations…


Wait types in SQL Server

Troubleshooting performance issues in SQL Server involves studying the wait types and wait times associated with the queries executing. However, the relevance of each of the various wait types in the output can be a mystery. For SQL Server 2000, the cumulative wait types can be observed using the DBCC SQLPERF(WAITSTATS) command. To clear the…


Tracer tokens in Transactional Replication

A new feature of SQL Server 2005 Transactional Replication is the ability to use “Tracer Tokens” to measure true latency between publisher-distributor and also distributor-subscriber. More details at Measuring Latency and Validating Connections for Transactional Replication.


Database Mirroring Technical Paper

One of the most exciting new features in SQL Server 2005 is DB Mirroring. Now that Service Pack 1 is released, we officially support this feature.   A really useful resource to understand the options available in using this feature and their pros / cons is the “Database Mirroring Best Practices and Performance Considerations” paper….


Database Snapshots

DB Snapshots are a very useful new feature in SQL Server 2005 Enterprise Edition. They provide us the ability to preserve a consistent picture of the database as it was at a point in time. Both metadata and data are captured in the snapshot.   The main uses of snapshots are for preserving views of…