SQLServer 2k users 100% CPU

  • My website have a table with 200.000 row. It have many query select, update, insert in a time. My data server have 2 CPU dual core 3 Ghz Xeon, this CPU Usage is 100%. I have any solution for it.

  • What are the 2 users running on the server??

     

    Is there any other task running (index defrag, databaseshrink, profiler, anti-virus)?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply