Hi,
I have mssql 2000 std sp4 running on w2k3 std sp2. intermittently users
experience slowness in accessing the database but users with elevated access
such as domain admins never experience such slowness when everybody else is
sufferring.
Please help i am going insane.
Thanks
PabloAre the two groups connecting using different networks?
"pfrank61" <pfrank61@.discussions.microsoft.com> wrote in message
news:FAF8FA18-A4E9-42CC-8FA5-4EC4FD77B08B@.microsoft.com...
> Hi,
> I have mssql 2000 std sp4 running on w2k3 std sp2. intermittently users
> experience slowness in accessing the database but users with elevated
> access
> such as domain admins never experience such slowness when everybody else
> is
> sufferring.
> Please help i am going insane.
> Thanks
> Pablo|||No Jay, they are on the same network and even sometimes I ask them to login
into the same computer.
I must also add that when slowness happens and I reboot the SQL server
everything normalizes again.
Thanks
Pablo
"Jay" wrote:
> Are the two groups connecting using different networks?
> "pfrank61" <pfrank61@.discussions.microsoft.com> wrote in message
> news:FAF8FA18-A4E9-42CC-8FA5-4EC4FD77B08B@.microsoft.com...
> > Hi,
> > I have mssql 2000 std sp4 running on w2k3 std sp2. intermittently users
> > experience slowness in accessing the database but users with elevated
> > access
> > such as domain admins never experience such slowness when everybody else
> > is
> > sufferring.
> >
> > Please help i am going insane.
> >
> > Thanks
> > Pablo
>
>|||Hi Pablo
Ive got a similar situation.
SP calls from IIS (logged in to sql server with a certain sql server login)
time outs while same call with same parameters (captured from profiler) run
from Query Analyzer (logged in with another account, higher permission level)
have normal response times.
After restart of the sql server service boot situations (IIS and QA) works
fine.
Did you find out anymore on this?
Any other who can direct me regarding this?
SQL Server 2000, IIS 6. Memory, CPU etc looks fine.
Thanks!
/Tore
"pfrank61" wrote:
> No Jay, they are on the same network and even sometimes I ask them to login
> into the same computer.
> I must also add that when slowness happens and I reboot the SQL server
> everything normalizes again.
> Thanks
> Pablo
> "Jay" wrote:
> > Are the two groups connecting using different networks?
> >
> > "pfrank61" <pfrank61@.discussions.microsoft.com> wrote in message
> > news:FAF8FA18-A4E9-42CC-8FA5-4EC4FD77B08B@.microsoft.com...
> > > Hi,
> > > I have mssql 2000 std sp4 running on w2k3 std sp2. intermittently users
> > > experience slowness in accessing the database but users with elevated
> > > access
> > > such as domain admins never experience such slowness when everybody else
> > > is
> > > sufferring.
> > >
> > > Please help i am going insane.
> > >
> > > Thanks
> > > Pablo
> >
> >
> >|||Hi Tore,
My situation hasn't change and I am still rebooting the server evertime it
happens.\
Hello Guys we can't be the only guys experiencing this, Please help us out
with suggestions.
Thanks
Paul
"Tore" wrote:
> Hi Pablo
> Ive got a similar situation.
> SP calls from IIS (logged in to sql server with a certain sql server login)
> time outs while same call with same parameters (captured from profiler) run
> from Query Analyzer (logged in with another account, higher permission level)
> have normal response times.
> After restart of the sql server service boot situations (IIS and QA) works
> fine.
> Did you find out anymore on this?
> Any other who can direct me regarding this?
> SQL Server 2000, IIS 6. Memory, CPU etc looks fine.
> Thanks!
> /Tore
>
> "pfrank61" wrote:
> > No Jay, they are on the same network and even sometimes I ask them to login
> > into the same computer.
> > I must also add that when slowness happens and I reboot the SQL server
> > everything normalizes again.
> >
> > Thanks
> > Pablo
> >
> > "Jay" wrote:
> >
> > > Are the two groups connecting using different networks?
> > >
> > > "pfrank61" <pfrank61@.discussions.microsoft.com> wrote in message
> > > news:FAF8FA18-A4E9-42CC-8FA5-4EC4FD77B08B@.microsoft.com...
> > > > Hi,
> > > > I have mssql 2000 std sp4 running on w2k3 std sp2. intermittently users
> > > > experience slowness in accessing the database but users with elevated
> > > > access
> > > > such as domain admins never experience such slowness when everybody else
> > > > is
> > > > sufferring.
> > > >
> > > > Please help i am going insane.
> > > >
> > > > Thanks
> > > > Pablo
> > >
> > >
> > >
