Registered users    
MembershipMembership:
Latest New UserLatest:Tony lai kit
New TodayNew Today:11
New YesterdayNew Yesterday:13
User CountOverall:23318

Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12890
Marina Roos12507
Eriq Neale2114
Stan Guinn1913
Michael Patrick1912
Robert Pearman1770
Nick Pieters1425
Stewart Brown616
william warren593
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Subject: A question of SQL, but probably ISA
Prev Next
You are not authorized to post a reply.

Author Messages
Michael Patrick User is Offline
United States
Member since
10/26/2005

Platinum Membership
Posts: 1912

12/23/2005 05:34 PM  
I have a program that is run from the server via SQL.  There are about 8-10 users using this program at a time.  Lately we have seen a slow down of the programs performance.  I am concerned that perhaps the processes are getting bogged down because of ISA 2004 (It went allot faster when it was just ISA 2000).  So is there a way for the processes to bypass ISA all together?  I'd like to get some speed boost until I am able to get everyone onto my new gigabit network. 
 
Thanks!

Michael Patrick

"Technology Interpreter Extraordinaire"
CAD, BIM & SBS
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12890

12/23/2005 07:35 PM  
Are those users on the Lan that connect to the SQL server? If that is the case ISA does not have a lot to do with it though ISA logging could take a lot of resources on the server. You can use SQL profiler to see if SQL is the culprit and/or performance monitor to have a better view on what is going on on your server.

Mariëtte Knap Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > A question of SQL, but probably ISA



ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.