SQL Server running at 95% util

• Ferdi Gribb

  SSC Enthusiast

  Points: 125

  More actions

  January 4, 2006 at 11:09 pm

  #167568

  Hi Everyone

  I need some assistance , I have a situation where i have 750 users on 3 local vlan's connecting to a sql 2000 box (recently upgraded as we thought that was the problem) SQL is now running on a HP Itanium Dual xeon processor with 4 gb Ram on a gig Backbone. The user machines access the Sql box through an Access front end using system DSN ODBC drivers ,as soon as more that 500 or so users log in the processor utilisation on the SQL box jumps up to 95% from about 28% and stays there , and there goes the performance

  At the moment i am running 2 SQL servers to aleviate the problem, but i would really like to hear your suggestions , Is the Machine still under spec? 

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  January 4, 2006 at 11:37 pm

  #612779

  Please don't cross post...

  Answer in this forum instead...

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=248306

  Thanks...