SQL Server Performance Forum – Threads Archive
Bad performance of our SQL Server
We use: SQL Server 2000, and a .NET C# developed programm. The programm is doing some inserts and updates on the SQLserver.<br /><br />But: from time to time we see a huge performance leak. Example: to navigate takes normally 0.5 second, but at this time it takes 2, or sometimes 5 seconds.<br /><br />Now I’ve been running Perfmon, with the following results:<br /><br /><img src=’http://ieni.karmac.nl/img/performance150607.jpg’ border=’0′ /><br /><br />My question is:<br />what is limiting the capacity of my machine?<br />How can I upgrade this machine, so it can perform well?<br />What other monitors should I check?<br /><br /><br />Another few specs of our machine:<br /><br /> Manufacturer : <br /> Dell Computer Corporation<br /> <br />Model :<br /> PowerEdge 2800<br /> <br /> Microsoft(R) Windows(R) Server 2003, Standard Edition <br /> Version : 5.2.3790<br /> Service Pack 1 <br /> <br />Build Info 3790 <br /> <br />Processors :<br /> 4<br /> <br />Processor :<br /> Intel(R) Xeon(TM) CPU 2.80GHz<br /> <br /> Physical Memory : <br /> 3 GB <br /> <br /> Virtual Memory : <br /> 1 GB <br /> <br /> Drive Details <br />Drive ; Type ; File Type ; Capacity ; Free Space <br /> <br /> <br />C: ; Local Disk (=Operating System); NTFS ; 12.00 GB ; 7.19 GB <br /> <br />D: ; Local Disk (=Page file); NTFS ; 56.19 GB ; 49.37 GB <br /> <br />E: ; Local Disk (=SAN Rate10); NTFS ; 170.34 GB ; 79.82 GB <br /> <br /><br />Thanks for all your reactions!!<br />BartTry this article http://www.sql-server-performance.com/sql_server_performance_audit2.asp Tradeco wholesalers, drop shippers & trade network
]]>