SQL Server Performance Tuning

Server System Architecture, 2002

Intended Audience This article is intended to provide software developers and IT administrators a basis for comparing server systems. The focus is on platforms for Intel processors and Windows NT, 2000 Server operating systems. Server system architectures can change substantially in 2-4 years, so it is important to understand the new capabilities introduced in each […]

Troubleshooting SQL Server Full-Text Search Problems

Should you have problems with the SQL Server full-text search, review this troubleshooting checklist to help find potential solutions. 1. Check the hardware requirementsFor SQL Server 7.0, you should have: Alpha AXP, Intel or compatible platform Pentium 166 MHz or higher 64MB RAM or more (recommended) 180MB hard disk space For SQL Server 2000, you […]

SQL Server 7.0 and 2000 Trace Flags

Trace flags are used to temporarily enable or disable specific SQL Server database functions, allowing you to change default database behavior or to observe hidden database behavior, and will remain in effect until they are either manually turned off or SQL Server is restarted. Keep in mind that most trace flags are undocumented and Microsoft […]

SQL Server Hardware Performance Checklist

Return to Previous Article in the Series Performance Audit Checklist  Counter Name Average Minimum Maximum  Memory: Pages/sec  Memory: Available Bytes  Physical Disk: % Disk time  Physical Disk: Avg. Disk Queue Length  Processor: % Processor Time  System: Processor Queue Length  SQL Server Buffer: Buffer Cache Hit Ratio  SQL Server General: User Connections Enter your results in […]

Some Useful Undocumented SQL Server 2000 Trace Flags

In this article, I want to tell you what should you know about some undocumented SQL Server 2000 trace flags, and how you can use them for administration and monitoring of SQL Server 2000.Trace flags are used to temporarily set specific server characteristics, or to switch on or off a particular behavior. You can set […]

How to Perform a SQL Server Performance Audit

If you have been a DBA for long, then you will know that performance tuning SQL Server is not an exact science. And even if it were, it would still be difficult to find the “optimal” configuration for the “optimal” performance. This is because there are few absolutes when it comes to performance tuning. For […]

An Exclusive Interview with David Gugick, SQL Server Performance Expert and Software Developer

Tell us a little about yourself.Iā€™m the president of Intrinsic Design, Inc., a software company dedicated to writing database analysis software for Microsoft SQL Server. After receiving my electrical engineering degree from the University of Michigan back in 1989, I took that knowledge and entered the world of software development. Initially, the database world was […]

Interview with Carl Speshock, Author of the Microsoft SQL Server 2000 Database Administrator’s Guidebook

Find Out More About This Book From Amazon.com Carl Speshock has been a DBA in the Houston area for over 6 years, and is moving back to Oregon, although he will continue to maintain some presence in Texas. Most recently, he has consulted to Shell Oil Products USA and Shell Services International. In addition to […]

SQL Server 2000 Table Hints

As you advance in your skills as a Transact-SQL developer, or SQL Server database administrator, there will come a time when you need to override SQL Server’s locking scheme and force a particular range of locks on a table. Transact-SQL provides you with a set of table-level locking hints that you can use with SELECT, […]

Some Useful Undocumented SQL Server 7.0 Trace Flags

In this article, I want to tell you what should you know about some undocumented SQL Server 7.0 trace flags, and how you can use them for administration and monitoring.Trace flags are used to temporarily set specific server characteristics, or to switch on or off a particular behavior. You can set trace flags by using […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |