MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.
Quote:> We have a software system powered by SQL Server 6.5 on NT 4.0.
> We have encountered a new situation in the last week twice, and that is
> decreasing of speed of the Database.
> Our queries get two slow to execute. But this situation does not exist on
> the server itself and queries are executed normally on the server itself.
> (we have used ISQL to examine the query execution speed on both clients
> While the network traffic is low the query execution time is too high.
> For the first time, the problem disapeared eventually and we did not find
> anything about the problem, and now at the second time, we don't know what
> to do. Please help us.
> Thank you.
When logged into NT under my own ID (admin group and database DBO) some MS
Access queries on SQL Server attached tables seem to execute much faster
than if I log into the same box under anyone else's ID. The queries still
complete but take up to 50 times longer.
Does anyone know anything about this? Can anyone help?