Drastic slowdown on SQL Server

One of our customers has SBS Server 2003 and after 5-6 hours of use the
server seems to slow down dramatically so that just retrieving records from
a small table takes sometimes 30 seconds when it normally takes less that 1.
We have hourly differential backups but they only take 5-10 seconds to run.
Can anyone guide me on what I can do to avoid this? It acts like all of the
memory is used up, but when I go into Taks Manager, the CPU useage is only
3%. Thanks.
Davidare there too many open connections to the server ?
also can you try to see the server response time without the differential
backups.
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:uLL4GY3GFHA.3272@.TK2MSFTNGP10.phx.gbl...
> One of our customers has SBS Server 2003 and after 5-6 hours of use the
> server seems to slow down dramatically so that just retrieving records
> from a small table takes sometimes 30 seconds when it normally takes less
> that 1. We have hourly differential backups but they only take 5-10
> seconds to run. Can anyone guide me on what I can do to avoid this? It
> acts like all of the memory is used up, but when I go into Taks Manager,
> the CPU useage is only 3%. Thanks.
> David
>|||Since it is SBS I have to assume you have other apps running on the server
than Sql Server. As such you should set a MAX memory setting in SQL Server
to assure the other apps and the OS have at least some memory to use. I
rarely see SBS servers where the apps are not fighting each other for
memory. How much do you have and how is the memory configured for SQL
Server?
Andrew J. Kelly SQL MVP
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:uLL4GY3GFHA.3272@.TK2MSFTNGP10.phx.gbl...
> One of our customers has SBS Server 2003 and after 5-6 hours of use the
> server seems to slow down dramatically so that just retrieving records
> from a small table takes sometimes 30 seconds when it normally takes less
> that 1. We have hourly differential backups but they only take 5-10
> seconds to run. Can anyone guide me on what I can do to avoid this? It
> acts like all of the memory is used up, but when I go into Taks Manager,
> the CPU useage is only 3%. Thanks.
> David
>|||sounds like resource blocking or deadlocks to me.
Have you checked sp_Who2 to see if blocking is the culprit?
Greg Jackson
PDX, Oregon|||The memory is 1.5GB
I did not setup their server so I'm not sure of memory configuration. I
would guess they used whatever it defaults to.
David
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uVMitp3GFHA.1476@.TK2MSFTNGP09.phx.gbl...
> Since it is SBS I have to assume you have other apps running on the server
> than Sql Server. As such you should set a MAX memory setting in SQL
> Server to assure the other apps and the OS have at least some memory to
> use. I rarely see SBS servers where the apps are not fighting each other
> for memory. How much do you have and how is the memory configured for SQL
> Server?
>
> --
> Andrew J. Kelly SQL MVP
>
> "David C" <dlchase@.lifetimeinc.com> wrote in message
> news:uLL4GY3GFHA.3272@.TK2MSFTNGP10.phx.gbl...
>|||Where do I check for open connections?
David
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||One more thing I should mention. This was NOT happening when they were
running SBS 2000. if that helps any.
David
"Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
news:e42sRn3GFHA.576@.TK2MSFTNGP15.phx.gbl...
> are there too many open connections to the server ?
> also can you try to see the server response time without the differential
> backups.
>
> "David C" <dlchase@.lifetimeinc.com> wrote in message
> news:uLL4GY3GFHA.3272@.TK2MSFTNGP10.phx.gbl...
>|||If it is the defaults then sql server will attempt to use all 1.5GB if there
is enough data. Then it will constantly compete with the other apps and the
OS for memory. Have them try setting the MAX Memory setting to SQL Server
to say 1.0 GB and see if that helps some. Depending on what the other apps
are doing you may even want to go lower.
Andrew J. Kelly SQL MVP
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:OVTIxz3GFHA.2620@.tk2msftngp13.phx.gbl...
> The memory is 1.5GB
> I did not setup their server so I'm not sure of memory configuration. I
> would guess they used whatever it defaults to.
> David
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uVMitp3GFHA.1476@.TK2MSFTNGP09.phx.gbl...
>|||sp_Who2 is a good start
Greg Jackson
PDX, Oregon|||sp_Who2 was a great help! Turns out, someone had checked the AutoShrink
checkbox and it was running and grinding everything to a halt.
David
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!sql