I am running an accounting program that uses SQL Server 2000 SP3 for the back
end and uses Access 2003 RT for a user interface. There is about 200000 rows
per table with about 150 tables. My problem is that at what seems to be a
random interval everyone that has the accounting system running on their
machines will pause for about 30 seconds and then continue as normal. This
will occur about ever 30-45 minutes, but occassionaly will skip a "pulse". I
am at a commplete lost here for what is to be done, so any help would be

Kevin,

That's not a lot to go on but it sounds like you may be having issues with
checkpoints. When a checkpoint occurs all the dirty buffers are written to
disk and if the disks are not beefy enough you can get a delay sensation for
a while until they finish writing all the pages to disk. Of coarse there
are lots of things that can cause something like this and you have to do a
little more investigating to narrow down the culprit. Have you done any
performance monitoring or profile traces to get an idea of what may be going
on? These may help:


http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring



--
Andrew J. Kelly SQL MVP


[quoted text, click to view]