|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL server performanceI have SQL Server 2000 run on 2 processors with 2gig of RAM on Windows
Server 2003. I run select and insert statement for about 1 million records thru a client php scripts and it runs very slow. I check the memory usage, sqlservr.exe consumes about 1 gig of Memory. "Dynamically configure SQL server merory" is selected with maxium(MB) = 2039MB Processor: and CPU usage is about 70%. Processor Control: Use Windows NT fibers Parallelism: Use all available processors Is my setting corrected, Any help to solve the slowliness problem would be greatly appreciated, Thanks, Culam Inserting 1 million rows one at a time thru a client app will always be
somewhat slow. You might want to see if you can Bulk Load them instead with BCP, Bulk Insert or DTS. But it is pretty hard to say what is the bottleneck without much more info. It could very well be the php scripts. But I can say you should not be using Fiber mode. Change it back to Threads. Make sure the Transaction Log files are on a separate physical hard drive than the data. Here are some links to have a look at: 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 -- Show quoteAndrew J. Kelly SQL MVP "culam" <cu***@discussions.microsoft.com> wrote in message news:49DAC4AA-5F1C-45B0-B97C-656774DEB9B8@microsoft.com... > > I have SQL Server 2000 run on 2 processors with 2gig of RAM on Windows > Server 2003. > I run select and insert statement for about 1 million records thru a > client > php scripts and it runs very slow. > I check the memory usage, > sqlservr.exe consumes about 1 gig of Memory. > "Dynamically configure SQL server merory" is selected with maxium(MB) = > 2039MB > > Processor: > and CPU usage is about 70%. > Processor Control: Use Windows NT fibers > Parallelism: Use all available processors > > Is my setting corrected, Any help to solve the slowliness problem would be > greatly appreciated, > > Thanks, > Culam  |
|||||||||||||||||||||||
Other interesting topics