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.
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" |
|
|
DLTaylor
Posting Yak Master
136 Posts |
Posted - 2009-05-14 : 08:08:32
|
Thanks PesoMemory 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? |
|
|
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" |
|
|
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? |
|
|
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 timeAvg Disk writes and read /sec and how many drives you have and what RAID are you using? |
|
|
|
|
|