how to reduce refrsh times in IIS and MS-SQL???

[OutHouse]

my users accessing timeclock webapp are complaining that the refresh screens are taking a long time. I have contacted the company about this and they said to make the adjustments in IIS and SQL to make the refresh times faster.

where do i do this in both IIS and SQL????

 

[KLin]

They didn't tell you how to do it? Sounds like a worthless company to me. Are you talking about refreshing data or just the screen?

 

[OutHouse]

data, the managers are bitching because after they enter data it takes a while (subjective) for the screen to upload the new data. Its not a server problem we installed this timeclock program and db on brand new dell 1850's.

 

[Mark R]

I assume that you mean, that it takes a long time to refresh the page. i.e. manager presses a button to upload new data, and it then takes a long time for the new screen to appear. If this is not correct, please ignore the rest of this post.

What are the loads on your server and network like?

Use the performance monitor on the server to check the CPU and network capacities.
Also check the event log, in particular look for events coming from w3svc, which is IIS. Errors, or warnings should give a clue as to the problem.

Check in IIS manager that you haven't limited the bandwidth or CPU time allotted to the timeclock program.


That said, it really needs be the supplier to advise you on this. They know how their software works and how it should be configured. Anyone else is just guessing. If they can't help, then perhaps you need to consider returning the software and cancelling your support contract - at least that's what you should tell their customer support dept.