Performance Problem in MS SQL 2000 Server

Question

Performance Problem in MS SQL 2000 Server

Srinivas-302011

SSC Rookie

Points: 38

March 28, 2006 at 8:13 am

Hi,

I need your help regarding the memory utilization problem in MS

SQL 2000 server. (Ent.Edition).

 Initially the SQL Service is utilizing low memory. But the

Memory utilization is increasing drastically (up to GBs) and the server is

getting slow when the users (below 10) are accessing the database.

 Please give the procedure for increasing the performance of the SQL

Server 2000

Thanks & Regards

Sreenivas.S

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

allen davidson SSCertifiable Points: 7042 More actions · Answer 1

Hi, Troubleshooting performance problems are always difficult - even when you are in front of the server. Can you give us some more background? In particular:

Has this only just started? What else is going on with the server? Is the hardware OK?

What else is the server used for? What other processes are running?

Is it the read or the write thats slow?

The usual culprits are db files autogrowing, poor indexing, statistics not updated. Using a lot of memory is (by itself) not neccesarily a performance issue.

After checking the above I would put a trace on and filter for events taking longer than 1 second.

Allen

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Agree with above. I would also run performance monitor and check for memory usage, page swapping, hard disk usage, processor usage.

Is the server dedicated to SQL Server? If not, what else is running on it?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 3