• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

Performance degradation when using SQL logging...

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA Server 2000 General] >> General >> Performance degradation when using SQL logging... Page: [1]
Login
Message << Older Topic   Newer Topic >>
Performance degradation when using SQL logging... - 7.Jun.2003 3:29:00 AM   
abergt

 

Posts: 4
Joined: 29.May2003
Status: offline
Greetings!

We're running ISA Enterprise on 2000 Server, dual 2.4 Xeons, 4GB RAM, with N2H2's BESS filtering plugin. It works great.

We have another server running SQL Enterprise 2000 on 2000 Server, single 2.4 Xeon, 4GB RAM.
Nothing is using it at the moment.

Both systems are on the same internal switch, running at 100FDX.

I've enabled ISA to log to the SQL server. Everything seems to work great -- except for one problem:

Our typical load is around 600 (anon SecureNAT) clients. This pulls around 50% CPU utilization with +/- 20% spikes, and gets pretty close to full utilization of our 11MB upstream link.

When I enable SQL logging, CPU utilization drops to a near-constant 30%, and upstream traffic bandwidth drops down to about 6MB. Needless to say, performance hits the floor. Some sites will even begin to time-out.

I've tried a dedicated NIC on both the SQL and ISA boxes with a crossover cable between, with the same results.

SQL seems to be performing fine, pulling 150-200tps with under 7% CPU utilization and occasional disk access.

Any suggestions for eliminating this performance issue?

I've tried limiting the fields used by ISA logging, but that only seems to work for the file-based logging -- SQL wants the whole enchilada.

I've also tried only logging the web proxy log. That helps, but still has a noticeable impact.

Thanks for your time!
Andrew
Post #: 1
RE: Performance degradation when using SQL logging... - 10.Jun.2003 7:59:00 PM   
abergt

 

Posts: 4
Joined: 29.May2003
Status: offline
Bump. [Confused]

(in reply to abergt)
Post #: 2
RE: Performance degradation when using SQL logging... - 29.Jul.2003 3:10:00 PM   
aselicean

 

Posts: 260
Joined: 7.Dec.2002
From: Romania
Status: offline
Hi Andrew

I was browsing the archive and noticed your post. Is still the case or you managed to solve your problem ?

Cheers,

(in reply to abergt)
Post #: 3

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2000 General] >> General >> Performance degradation when using SQL logging... Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts