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 Tech Forum
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.
|
