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.
David
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...
> 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!

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

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...
>> 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
>|||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...
>> 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
>|||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...
>> 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
>>
>

drastic change in speed

I was executing sp, which was taking time. I then dropped it and recreated
it. It started executing very fast.
Can Anyone have idea why this happens and what exactly happen when we drop
and recreate sp.When you drop SP it will cause to recompilation ( generating a new execution
plan). The same thing you might achive by creating a stored procedure WITH
RECOMPILE option
For more details see BOL
"Vikram" <aa@.aa> wrote in message
news:%23QQDPBcQGHA.1676@.TK2MSFTNGP14.phx.gbl...
>I was executing sp, which was taking time. I then dropped it and recreated
> it. It started executing very fast.
> Can Anyone have idea why this happens and what exactly happen when we drop
> and recreate sp.
>|||Also, before recompiling all the stored procedures, look into running DBCC
UPDATEUSAGE for critical tables. This will incure that the new execution
plans are compiled using the latest usage statistics.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:euJAtBdQGHA.2012@.TK2MSFTNGP14.phx.gbl...
> When you drop SP it will cause to recompilation ( generating a new
> execution plan). The same thing you might achive by creating a stored
> procedure WITH RECOMPILE option
> For more details see BOL
>
>
> "Vikram" <aa@.aa> wrote in message
> news:%23QQDPBcQGHA.1676@.TK2MSFTNGP14.phx.gbl...
>

drastic change in response time

All processes have slowed to a crawl - 1 user running a
simple query in ARC brings all app's residing on this
machine to a crawl. Machine resourses are abundant and
available. I know these are VERY sparse details... I'll
provide whatever info I can if someone can let us know
something. ThanxThis is a multi-part message in MIME format.
--=_NextPart_000_04C0_01C3CE1E.3D63B070
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Some suggestions:
1. Run DBCC OPENTRAN for your database. See what SPID has the longest
running txn. Run DBCC INPUTBUFFER on the SPID.
2. Run sp_lock and see who is putting up the most locks.
3. Based on the above, consider killing the offending SPID.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:07aa01c3ce47$4cc7aca0$a001280a@.phx.gbl...
All processes have slowed to a crawl - 1 user running a
simple query in ARC brings all app's residing on this
machine to a crawl. Machine resourses are abundant and
available. I know these are VERY sparse details... I'll
provide whatever info I can if someone can let us know
something. Thanx
--=_NextPart_000_04C0_01C3CE1E.3D63B070
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Some suggestions:
1. Run DBCC OPENTRAN =for your database. See what SPID has the longest running txn. Run =DBCC INPUTBUFFER on the SPID.
2. Run sp_lock and =see who is putting up the most locks.
3. Based on =the above, consider killing the offending SPID.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"David" wrote in message news:07aa01c3ce47$4c=c7aca0$a001280a@.phx.gbl...All processes have slowed to a crawl - 1 user running a simple query in =ARC brings all app's residing on this machine to a crawl. Machine resourses are abundant and available. I know these are VERY =sparse details... I'll provide whatever info I can if someone can let us =know something. Thanx

---

--=_NextPart_000_04C0_01C3CE1E.3D63B070--|||What are your server specs? Can you run other operations on the server
quickly(ie. is it SQL or the whole box)?
Other things to list --
mem usage
Free pages
IO
CPU usage
Cost of the query in question
We have had random slow and stoppage of performance on SQL2K.
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:07aa01c3ce47$4cc7aca0$a001280a@.phx.gbl...
> All processes have slowed to a crawl - 1 user running a
> simple query in ARC brings all app's residing on this
> machine to a crawl. Machine resourses are abundant and
> available. I know these are VERY sparse details... I'll
> provide whatever info I can if someone can let us know
> something. Thanx|||1gb RAM
4gb harddrive available (about 40%)
2 - 933 processors
ALL application are affected. Task Mgr show both 933
processors at 100 capacity. All seem fine until we run a
simple SQL query on an ARC database. THAT qry soaks up
100% RAM.
>--Original Message--
>What are your server specs? Can you run other operations
on the server
>quickly(ie. is it SQL or the whole box)?
>Other things to list --
>mem usage
>Free pages
>IO
>CPU usage
>Cost of the query in question
>We have had random slow and stoppage of performance on
SQL2K.
>"David" <anonymous@.discussions.microsoft.com> wrote in
message
>news:07aa01c3ce47$4cc7aca0$a001280a@.phx.gbl...
>> All processes have slowed to a crawl - 1 user running a
>> simple query in ARC brings all app's residing on this
>> machine to a crawl. Machine resourses are abundant and
>> available. I know these are VERY sparse details... I'll
>> provide whatever info I can if someone can let us know
>> something. Thanx
>
>.
>|||What is the cost of the query? Can you run --
SET SHOWPLAN_ALL ON
GO
<QUERY IN QUESTION>
and post the output.
Also there is a SQL bug on SQL2K that will create mem leaks when jumping
between DBs in a query, is that happening? What version of SQL and SP are
you on?
"DAvid" <anonymous@.discussions.microsoft.com> wrote in message
news:02f501c3ce4c$25d52d70$a301280a@.phx.gbl...
> 1gb RAM
> 4gb harddrive available (about 40%)
> 2 - 933 processors
> ALL application are affected. Task Mgr show both 933
> processors at 100 capacity. All seem fine until we run a
> simple SQL query on an ARC database. THAT qry soaks up
> 100% RAM.
>
> >--Original Message--
> >What are your server specs? Can you run other operations
> on the server
> >quickly(ie. is it SQL or the whole box)?
> >
> >Other things to list --
> >mem usage
> >Free pages
> >IO
> >CPU usage
> >Cost of the query in question
> >
> >We have had random slow and stoppage of performance on
> SQL2K.
> >
> >"David" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:07aa01c3ce47$4cc7aca0$a001280a@.phx.gbl...
> >> All processes have slowed to a crawl - 1 user running a
> >> simple query in ARC brings all app's residing on this
> >> machine to a crawl. Machine resourses are abundant and
> >> available. I know these are VERY sparse details... I'll
> >> provide whatever info I can if someone can let us know
> >> something. Thanx
> >
> >
> >.
> >|||Please elaborate on this "bug"., KB articles, PSS cases, thanks.
--
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Kevin Brooks" <jeepnreb@.yahoo.com> wrote in message
news:uL9#ZMlzDHA.2456@.TK2MSFTNGP10.phx.gbl...
> What is the cost of the query? Can you run --
> SET SHOWPLAN_ALL ON
> GO
> <QUERY IN QUESTION>
> and post the output.
> Also there is a SQL bug on SQL2K that will create mem leaks when jumping
> between DBs in a query, is that happening? What version of SQL and SP are
> you on?
>
> "DAvid" <anonymous@.discussions.microsoft.com> wrote in message
> news:02f501c3ce4c$25d52d70$a301280a@.phx.gbl...
> > 1gb RAM
> > 4gb harddrive available (about 40%)
> > 2 - 933 processors
> >
> > ALL application are affected. Task Mgr show both 933
> > processors at 100 capacity. All seem fine until we run a
> > simple SQL query on an ARC database. THAT qry soaks up
> > 100% RAM.
> >
> >
> > >--Original Message--
> > >What are your server specs? Can you run other operations
> > on the server
> > >quickly(ie. is it SQL or the whole box)?
> > >
> > >Other things to list --
> > >mem usage
> > >Free pages
> > >IO
> > >CPU usage
> > >Cost of the query in question
> > >
> > >We have had random slow and stoppage of performance on
> > SQL2K.
> > >
> > >"David" <anonymous@.discussions.microsoft.com> wrote in
> > message
> > >news:07aa01c3ce47$4cc7aca0$a001280a@.phx.gbl...
> > >> All processes have slowed to a crawl - 1 user running a
> > >> simple query in ARC brings all app's residing on this
> > >> machine to a crawl. Machine resourses are abundant and
> > >> available. I know these are VERY sparse details... I'll
> > >> provide whatever info I can if someone can let us know
> > >> something. Thanx
> > >
> > >
> > >.
> > >
>|||Will have to respond tomorrow - office is closed for the
day
>--Original Message--
>What is the cost of the query? Can you run --
>SET SHOWPLAN_ALL ON
>GO
><QUERY IN QUESTION>
>and post the output.
>Also there is a SQL bug on SQL2K that will create mem
leaks when jumping
>between DBs in a query, is that happening? What version
of SQL and SP are
>you on?
>
>"DAvid" <anonymous@.discussions.microsoft.com> wrote in
message
>news:02f501c3ce4c$25d52d70$a301280a@.phx.gbl...
>> 1gb RAM
>> 4gb harddrive available (about 40%)
>> 2 - 933 processors
>> ALL application are affected. Task Mgr show both 933
>> processors at 100 capacity. All seem fine until we run
a
>> simple SQL query on an ARC database. THAT qry soaks up
>> 100% RAM.
>>
>> >--Original Message--
>> >What are your server specs? Can you run other
operations
>> on the server
>> >quickly(ie. is it SQL or the whole box)?
>> >
>> >Other things to list --
>> >mem usage
>> >Free pages
>> >IO
>> >CPU usage
>> >Cost of the query in question
>> >
>> >We have had random slow and stoppage of performance on
>> SQL2K.
>> >
>> >"David" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:07aa01c3ce47$4cc7aca0$a001280a@.phx.gbl...
>> >> All processes have slowed to a crawl - 1 user
running a
>> >> simple query in ARC brings all app's residing on this
>> >> machine to a crawl. Machine resourses are abundant
and
>> >> available. I know these are VERY sparse details...
I'll
>> >> provide whatever info I can if someone can let us
know
>> >> something. Thanx
>> >
>> >
>> >.
>> >
>
>.
>|||It was a bug that hit us a few years back. We did not open a PSS case, but
you can search KB for it(if they acknowledge it). The client apps where
made in PB and a SQL2K(Compaq) server gold release. We no longer see this
problem and are on SP3a/SP2. It was a sporatic and not a serious outage at
the time, it sounded familar to is problem though.
"Kevin" <ReplyTo@.Newsgroups.only> wrote in message
news:uKFCBJmzDHA.1760@.TK2MSFTNGP10.phx.gbl...
> Please elaborate on this "bug"., KB articles, PSS cases, thanks.
> --
> Kevin Connell, MCDBA
> ----
> The views expressed here are my own
> and not of my employer.
> ----
> "Kevin Brooks" <jeepnreb@.yahoo.com> wrote in message
> news:uL9#ZMlzDHA.2456@.TK2MSFTNGP10.phx.gbl...
> > What is the cost of the query? Can you run --
> >
> > SET SHOWPLAN_ALL ON
> > GO
> > <QUERY IN QUESTION>
> >
> > and post the output.
> >
> > Also there is a SQL bug on SQL2K that will create mem leaks when jumping
> > between DBs in a query, is that happening? What version of SQL and SP
are
> > you on?
> >
> >
> > "DAvid" <anonymous@.discussions.microsoft.com> wrote in message
> > news:02f501c3ce4c$25d52d70$a301280a@.phx.gbl...
> > > 1gb RAM
> > > 4gb harddrive available (about 40%)
> > > 2 - 933 processors
> > >
> > > ALL application are affected. Task Mgr show both 933
> > > processors at 100 capacity. All seem fine until we run a
> > > simple SQL query on an ARC database. THAT qry soaks up
> > > 100% RAM.
> > >
> > >
> > > >--Original Message--
> > > >What are your server specs? Can you run other operations
> > > on the server
> > > >quickly(ie. is it SQL or the whole box)?
> > > >
> > > >Other things to list --
> > > >mem usage
> > > >Free pages
> > > >IO
> > > >CPU usage
> > > >Cost of the query in question
> > > >
> > > >We have had random slow and stoppage of performance on
> > > SQL2K.
> > > >
> > > >"David" <anonymous@.discussions.microsoft.com> wrote in
> > > message
> > > >news:07aa01c3ce47$4cc7aca0$a001280a@.phx.gbl...
> > > >> All processes have slowed to a crawl - 1 user running a
> > > >> simple query in ARC brings all app's residing on this
> > > >> machine to a crawl. Machine resourses are abundant and
> > > >> available. I know these are VERY sparse details... I'll
> > > >> provide whatever info I can if someone can let us know
> > > >> something. Thanx
> > > >
> > > >
> > > >.
> > > >
> >
> >
>|||Problem turned out not to be SQL Server generated. Was
instead a problem with SDE reconciliation...sorry!
david
>--Original Message--
>All processes have slowed to a crawl - 1 user running a
>simple query in ARC brings all app's residing on this
>machine to a crawl. Machine resourses are abundant and
>available. I know these are VERY sparse details... I'll
>provide whatever info I can if someone can let us know
>something. Thanx
>.
>