- The Windows 2000\XP\.NET Resource Index
Home | About Us | Search

Last Updated December 16, 2003


SQL Server 2000
Where to Start
Backup and Recovery
Install & Configuration
Performance Tuning

Troubleshooting SQL Server 2000


Where to Start
Ask the SQL Server experts
Ask leading SQL Server gurus your toughest administration or development questions or browse the collection of 400+ questions already answered.

Common SQL Mail Problems
Microsoft Knowledge Base Article: 315886 - This article uses a question and answer format to identify common problems you may encounter when you work with SQL Mail and provides you with some tips on how to correct or troubleshoot these problems. The vast majority of SQL Mail related problems are due to an improper configuration. For additional information on how to correctly configure SQL Mail, click the article number below to view the article in the Microsoft Knowledge Base: 263556 INF: How to Configure SQL Mail  This article presumes a working knowledge of the background information provided in Q263556. Unless otherwise stated, comments in this article regarding SQL Mail also apply to SQLAgentMail

HOW TO: Determine Proper SQL Server Configuration Settings
Microsoft Knowledge Base Article: 319942 - This article describes the following configuration settings and considerations for their use: Affinity Mask Lightweight Pooling Max Async IO Max Worker Threads Memory Priority Boost Set Working Set Size SQL Server can obtain a very high level of performance with relatively little configuration tuning. You can obtain high levels of performance by using good application and database design, and not by extensive configuration tuning. See the "References" section of this article for information about how to troubleshoot various SQL Server performance issues

HOW TO: Identify Your SQL Server Service Pack Version and Edition 
Microsoft Knowledge Base Article: 321185 - This article describes how to identify your current SQL Server version number and corresponding product or service pack (SP) level. It also describes how to identify the specific edition if you are using SQL Server 7.0 or SQL Server 2000. 


HOW TO: Log Data Transformation Services Package Execution to a Text File
Microsoft Knowledge Base Article: 316043 - SQL Server can log information about package execution and the detailed step level execution in a package to a text file. You can use the text log file to troubleshoot both package level and step level errors. This article describes how you enable logging to a text file

HOW TO: Remove a SQL Server Service Pack
Microsoft Knowledge Base Article: 314823 - This step-by-step article describes how to remove a SQL Server service pack and expands on the information contained in the Readme.txt file for each service pack. When you install a new service pack, the service pack makes changes to the system tables for maintenance reasons, and upgrades user and distribution databases that are members of a replication topology. Due to these changes, you cannot easily remove service packs. There is no automated way to remove a service pack, and the process of removing a service pack involves several manual steps and risks if not done correctly.

HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
Microsoft Knowledge Base Article: 243588 - This article describes how to troubleshoot the slow performance of many concurrent ad-hoc queries

HOW TO: Troubleshoot Application Performance Issues
Microsoft Knowledge Base Article: 298475 - To troubleshoot performance issues, you must complete a series of steps to isolate and determine the cause of the problem

HOW TO: Troubleshoot a SQL Server Desktop Engine 2000 Installation and Upgrade
Microsoft Knowledge Base Article: 317328 - SQL Server 2000 Desktop Engine (also known as MSDE 2000) is a data engine that is built and based on core SQL Server technology. With support for single and dual-processor desktop computers, MSDE 2000 is a reliable storage engine and query processor, for desktop extensions of enterprise applications. With the common technology base that SQL Server and MSDE 2000 share, developers can build applications that can scale seamlessly from portable computers to multiprocessor clusters

HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later
Microsoft Knowledge Base Article: 243589 -This article describes how to handle a performance issue that applications may experience in conjunction with Microsoft SQL Server: slow performance of a specific query or group of queries

SQL Server IT Knowledge Exchange
A discussion forum for SQL Server administrators and developers. This is the place to find solutions to your problems. Your questions are usually answered in less than a day!

Support WebCast: Analyzing Optimal Compiled Plan Caching
During this Support WebCast, we will cover the different ways that you can submit queries to SQL Server, and the plan caching associated to each of them. We will discuss the plan caching mechanism in SQL Server, its merits and its flaws. We will also talk about techniques to improve plan caching for database queries, and explain the options that you can use to avoid poor plan caching

Support Webcast: Microsoft SQL Server: Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
This Support WebCast session will discuss how to troubleshoot SQL Server 2000 virtual server and service pack setups for failover clustering. This WebCast will help you understand the virtual server setup process. It will review setup files for unsuccessful virtual setups and service pack setups. The WebCast will discuss the SQL Server 2000 Service Pack 3 preinstallation checklist for SQL Server 2000 virtual server for failover clustering.

Support WebCast: Microsoft SQL Server 2000: Troubleshooting Connectivity
Troubleshooting SQL Server connectivity can be challenging. This Support WebCast will present methods to help you resolve common connectivity issues that may occur in Microsoft SQL Server 2000. It will also discuss many of the tools that are available to make troubleshooting easier.

Support WebCast: Microsoft SQL Server 2000 Analysis Services: How to Connect to Analysis Services over the Internet
In this session, we will discuss how to configure and troubleshoot an HTTP connection to Analysis Services over both the Internet and an intranet. We will show you how to configure Microsoft Internet Information Services (IIS), and discuss the different security options for IIS in regard to Analysis Services. We will also talk about the client connection string and performance issues that may arise while using the HTTP connection

Support WebCast: Troubleshooting Database Connectivity Issues in Programming with ASP
This session will cover general troubleshooting techniques that you can use for data access issues that may occur when you are programming from ASP.

Support WebCast: Troubleshooting Microsoft SQL Mail
In this session, we will discuss common problems, issues you may encounter when setting up and using Microsoft SQL Mail. The session will also include ideas and suggestions about how to troubleshoot the problems

Support WebCast: Microsoft SQL Server: How to Configure, Manage, Use, and Troubleshoot Linked Servers
In this Support WebCast session, you will learn how to set up, configure, write queries for, and troubleshoot various linked servers with Microsoft SQL Server. You will hear about the architecture of linked servers, and how to configure and then use various linked servers to access remote data sources. You will also learn common troubleshooting techniques and how to solve problems that involve linked servers.

Troubleshooting SQL Server 2000 Log Shipping "Out of Sync" Errors
Microsoft Knowledge Base Article: 329133 - This article discusses the reasons for "out of sync" error messages when you have log shipping configured for SQL Server 2000

Understanding and Troubleshooting the Copy Database Wizard in SQL Server 2000
Microsoft Knowledge Base Article: 274463 - The Copy Database Wizard is a new utility in SQL Server 2000 that allows you to move or copy a database from SQL Server 7.0 or from SQL Server 2000 to SQL Server 2000. The copy or move process is relatively straightforward and it may seem like the process barely affects anything. This article provides information on how the Copy Database Wizard works and outlines some issues to look out for when you use the wizard.


Entire contents
© 1999-2003 and TechTarget
All rights reserved

This site and its contents are Copyright 1999-2003 by Microsoft, NT, BackOffice, MCSE, and Windows are registered trademarks of Microsoft Corporation. Microsoft Corporation in no way endorses or is affiliated with The products referenced in this site are provided by parties other than makes no representations regarding either the products or any information about the products. Any questions, complaints, or claims regarding the products must be directed to the appropriate manufacturer or vendor.