Hi

If the users are compaling that the production environment
is slow, what are the sequence of steps/files to look into?


Thanks
vind

The first thing you should do is check to see if there's blocking in the
server. You can use sp_who (or sp_who2, which gives you additional info) to
get a list of processes and connections to the server. Then use sp_lock to
get detailed lock information by process. Use DBCC INPUTBUFFER to see the
query that a process is running, well, you get the first part of the query
if it's too long. Sometimes slowness is due to server load, so you can
monitor memory and cpus with performance monitor. You'll find more
information regarding specific performance monitor counters in books online.
Sp_who also gives you information about cpu and disk used by processes, so
you can use this info to detect long running queries, or queries that take a
lot of system resources.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example


"vind" <vind74 (AT) yahoo (DOT) com> wrote

check out the following presentations: Effective Indexing and Statistics with SQL 2000:
http://download.microsoft.com/downlo...WC070601.exeTo view,
please click on the link:


Performance troubleshooter: http://support.microsoft.com/support...7queryperf.asp

Articles that might help:

ID: 322322. INF: Identifying Common Administrative Issues for Microsoft SQL Server

Hina Masud
Microsoft

Disclaimer:
This posting is provided AS IS with no warranties, and confers no rights.
Get Secure! -> http://www.microsoft.com/security


--------------------
-Content-Class: urn:content-classes:message
-From: "vind" <vind74 (AT) yahoo (DOT) com>
-Sender: "vind" <vind74 (AT) yahoo (DOT) com>
-Subject: Troubleshooting
-Date: Fri, 11 Jul 2003 08:23:05 -0700
-Lines: 8
-Message-ID: <0b6701c347c0$5342de50$a501280a (AT) phx (DOT) gbl>
-MIME-Version: 1.0
-Content-Type: text/plain;
- charset="iso-8859-1"
-Content-Transfer-Encoding: 7bit
-X-Newsreader: Microsoft CDO for Windows 2000
-Thread-Index: AcNHwFNC0sInM2VESaahaTjeVJRVww==
-X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
-Newsgroups: microsoft.public.sqlserver.clustering
-Path: cpmsftngxa06.phx.gbl
-Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.clustering:10489
-NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
-X-Tomcat-NG: microsoft.public.sqlserver.clustering
-
-Hi
-
-If the users are compaling that the production environment
-is slow, what are the sequence of steps/files to look into?
-
-
-Thanks
-vind
-