Performance

I have a SQL server 7.0 which is installed on a dual
processors machine (NT4.0), when I try to do a query its
fairly slow, I have checked CPU utilization and memory
they are ok, is there anyway to find out what is wrong
here?
Also is there any tool I can check SQL server performance?
thanks in advance-RobCheck the query plan, also use profiler to see
the statistics of the query, such as reads, writes, etc.
>--Original Message--
>I have a SQL server 7.0 which is installed on a dual
>processors machine (NT4.0), when I try to do a query its
>fairly slow, I have checked CPU utilization and memory
>they are ok, is there anyway to find out what is wrong
>here?
>Also is there any tool I can check SQL server performance?
>thanks in advance-Rob
>.
>|||I am new this area, what is the query plan and how can I
use the profiler.
Thanks-rob
>--Original Message--
>Check the query plan, also use profiler to see
>the statistics of the query, such as reads, writes, etc.
>>--Original Message--
>>I have a SQL server 7.0 which is installed on a dual
>>processors machine (NT4.0), when I try to do a query its
>>fairly slow, I have checked CPU utilization and memory
>>they are ok, is there anyway to find out what is wrong
>>here?
>>Also is there any tool I can check SQL server
performance?
>>thanks in advance-Rob
>>.
>.
>|||Lookup Graphical Query Plan in Books on Line. Too hard to explain in a
newsgroup post.
The query plan will show you problems like Table Scans that can be solved
with more selective where clauses and/or applying indexes to table in
question.
There is obviously much more to it than that, but there is a start for you.
Also, visit www.sql-server-performance.com
Cheers,
Greg Jackson
Portland, OR|||Hi Rob,
You may also want to refer to these articles that may help you troubleshoot performance issues.
224587 HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/?id=224587
This step-by-step article describes how to troubleshoot SQL Server performance issues. Troubleshooting
performance issues involves the use of a series of steps to isolate and determine the cause of an application
slowdown.
~~~
243589 HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later
http://support.microsoft.com/?id=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.
~~~
243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/?id=243588
This article describes how to troubleshoot the slow performance of many concurrent ad-hoc queries.
~~~
224453 INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/?id=224453
This article focuses on how to monitor SQL Server to capture pertinent system information and how to analyze
that information to successfully resolve blocking issues.
~~~
Sincerely,
William Wang
Microsoft Partner Online Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Jaxon" <GregoryAJackson@.hotmail.com>
> References: <045401c3a960$5eccf1f0$a301280a@.phx.gbl> <037501c3a964$e45d7660$a401280a@.phx.gbl>
<05b301c3a966$30440bb0$a101280a@.phx.gbl>
> Subject: Re: Performance
> Date: Wed, 12 Nov 2003 16:31:22 -0800
> Lines: 19
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> Message-ID: <OKLL41XqDHA.2964@.tk2msftngp13.phx.gbl>
> Newsgroups: microsoft.public.sqlserver.server
> NNTP-Posting-Host: 66.203.99.51
> Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:316205
> X-Tomcat-NG: microsoft.public.sqlserver.server
> Lookup Graphical Query Plan in Books on Line. Too hard to explain in a
> newsgroup post.
> The query plan will show you problems like Table Scans that can be solved
> with more selective where clauses and/or applying indexes to table in
> question.
> There is obviously much more to it than that, but there is a start for you.
> Also, visit www.sql-server-performance.com
>
> Cheers,
>
> Greg Jackson
> Portland, OR
>
>