SQL taking a pounding

To the Ipswitch web site

Ipswitch Forums
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



SQL taking a poundingExpand / Collapse
Author
Message
Posted 9/29/2008 4:21:39 AM


Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 12/18/2008 6:41:10 PM
Posts: 45, Visits: 5,664
Since I loaded RC5, the SQL server process has been chewing more and more CPU time, to the point now where the server is so unresponsive that it is unusable; even from the console.

It seems that a load more data is being processed than before.

What sort of production SQL server is envisioned for a live environment, considering I am only looking at about 50 streams at the moment.

Post #47322
Posted 9/29/2008 1:40:57 PM
Time Traveler

Time TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime Traveler

Group: Ipswitch Employees
Last Login: Today @ 5:05:16 PM
Posts: 227, Visits: 1,332
Hi Lionel,

  I can imagine two posibilities, one is that previous RC were not able to process all received data, so SQL was ok with that load.  The second is due to a bug we have on RC5 that will update hosts very often, not paying attention to when its name needed to be resolved.  Do you know the number of flows per minute you have before and after RC5?  Had you looked at the log to see if everything seems ok?

Claudio Robles
Network Monitor Team

Post #47334
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Dave, Jason Benton, Jason Williams

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 7:01pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.047. 10 queries. Compression Enabled.