Slowness of a SQL Server
From: Paul (anonymous_at_discussions.microsoft.com)
Date: 05/17/04
- Next message: Mark Allison: "Re: Remote Desktop"
- Previous message: Mark Allison: "Re: Why my SQL 7.0 Merge Replication suddenly doesn't work ?"
- In reply to: Ashley West: "Slowness of a SQL Server"
- Next in thread: Ashley: "Slowness of a SQL Server"
- Reply: Ashley: "Slowness of a SQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 May 2004 09:03:42 -0700
Have a look on the Microsoft site for the SQL operations
guide. Its got lots of useful information, including
what counters to monitor.
Paul.
>-----Original Message-----
>I am very new to SQL Server dba world and I have a
server
>that is running very slow. I want to run some
performance
>monitoring or profiler and I like to know what counters
to
>add in order to figure out why the server is so slow.
In
>fact a simple select of 3000 rows takes like 8 - 10
>minutes to return something.
>
>On a similar server with a little bit more memore, it
>returns the results in a few seconds. Both tables have
>the necessary indexes - so I am just looking on the
server
>side what I can do. Please help if you can. Thank you.
>
>Ashley
>.
>
- Next message: Mark Allison: "Re: Remote Desktop"
- Previous message: Mark Allison: "Re: Why my SQL 7.0 Merge Replication suddenly doesn't work ?"
- In reply to: Ashley West: "Slowness of a SQL Server"
- Next in thread: Ashley: "Slowness of a SQL Server"
- Reply: Ashley: "Slowness of a SQL Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
