I'm running SQL Server 7 SP3 on Windows 2000, using an ODBC-driven
I start Enterprise Manager on the local machine running SQL Server and I
navigate until it is showing me the list of tables for my database. Then
I execute my application in another window on the same machine. It
works, and performance is good.
Then I close Enterprise Manager, and performance degrades significantly,
for no apparent reason. If I restart Enterprise Manager and navigate to
the table display, performance returns to normal.
Starting the application first doesn't change the behavior. I tried
rebooting several times.
Has anyone seen this before?