Re: Server REALLY REALLY Slow...!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Christiano
Are there any activities on the server while you rn the SELECT? Blocking?
Check out memory bottelneck



"Christiano" <cdonke@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%234$yA3wfKHA.1648@xxxxxxxxxxxxxxxxxxxxxxx
Hey there..

Plz...

I'm running a SQL Server v9.0.1406.
3 databases running. No replication, no automatic functions running.

A SELECT on a VIEW that returns 2569 rows, is taking up to 55 seconds.

And almost every DB requiment is taking a lot longer than it should..

Backed it up, and downloaded to my office. Restored it and there´s not
this delay... Nor something like it..

I don't know not even where to start. I don't think it's a database
issue... I'm betting more on a server issue..

Tkss for your help,
Christiano.



.

Relevant Pages

  • Re: OLE DB Error 999 "Object Was in Use"
    ... This is happening with the application running on one server, ... Other servers & databases running the same code do not ... examine the adodb errors collection. ... Enumerate the ADODB.Connection.Errorscollection to see the exact ADO ...
    (microsoft.public.data.ado)
  • Re: openSUSE MySQL Replication
    ... All this is new to me and I've come up with the term Replication. ... Everything on my site so far (no databases running there yet) is a ... I do all the stuff there and rsync my server directories with that. ... So I could keep working the way I'm used to, just the MySQL part would ...
    (alt.os.linux.suse)
  • Re: Server REALLY REALLY Slow...!!!
    ... server to bad settings to blocking to virtualized mess to missing indexes to ... SQL Server MVP ... I'm running a SQL Server v9.0.1406. ... databases running. ...
    (microsoft.public.sqlserver.server)
  • Re: DB Link ORA-12631 error when we set SQLNET.AUTHENTICATION_SERVICES= (NTS)
    ... We have a DB_Link between two databases running in two servers ... (Oracle9i Enterprise Edition Release 9.2.0.8.0 on Windows 2003 Server ... Enterprise Edition). ... from the server anyway will you... ...
    (comp.databases.oracle.server)
  • Java ErrorOracle 9.2 OEM 9.2 WinXP, Win2003
    ... I've two different databases running in a WinXP and Win2003 Server ... environment and the same effects. ...
    (comp.databases.oracle.misc)