Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Slow SQL server 2000

Author  Topic 

DLTaylor
Posting Yak Master

136 Posts

Posted - 2009-05-14 : 06:13:39

I have a Windows 2000 Server running SQL 2000.

Typically only I will access this sever to perform bulk deletes \ inserts \ exports etc...
These have run at good speeds for a period of time (2+ yrs)

The configuration of the database all looks ok (no rogue jobs \ poor indexes \processes etc...)

I believe the server itself is perhaps causing the problem – for someone like me who knows a bit about SQL – but not ‘server’ administration – what good advice \ tips \ articles – are available to give me some guidance on how best to deal with this type of problem?

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-14 : 07:06:21
Which part is experienced as slow?
Memory? Disk access? Other?


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

DLTaylor
Posting Yak Master

136 Posts

Posted - 2009-05-14 : 08:08:32
Thanks Peso

Memory is ok.
Disk access – is slow e.g. well written queries run slow (despite doing all the necessary table maintenance...)
and perhaps other...?

We are running from a virtual server – not sure if SQL experiences issues in this environment?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-14 : 11:30:27
SQL Server generally does not respond well to be running in a virtual environment


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

DLTaylor
Posting Yak Master

136 Posts

Posted - 2009-05-14 : 11:32:53
your telling me ..we have had a number of performance issues
(not necessarily this server though)
Any ideas how to best address – have you seen any articles?
- do you think the virtual server is potentially my problem?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-05-14 : 23:35:37
Post the counters result for:

Avg Disk Queue Length
% Disk time
Avg Disk writes and read /sec
and how many drives you have and what RAID are you using?
Go to Top of Page
   

- Advertisement -