Slooowww after MDAC 2.6

[JeffP]

MSSQL .7.0 SP2
WIN2KPRO
ATI 32mb video
1.3gh AMD
1g Ram

No other apps are affected....my once fast system is slowed to a crawl. 5+gb
free on C 37gb on E and NO apps loaded in systray. NO background processes,
nunca.

I installed MDAC 2.6 on a system to try to correct an OLE error when using
sp_OACreate that causes an ODBC connection broken and shuts down SQL every
other execution.

***** Now, the system is running slow, I tried reinstalling, moving the data
to a single local drive. (No other apps appear to be slowed)

Uninstalled MDAC 2.6 and reverted to 2.5 still slow.

Reinstalling MSSQL 7 and SP2, and MDAC 2.5 still slow...

As an example, when a simple xp_cmdShell 'dir c:mssql7data*data.mdf' the
resulting 10 lines are slowing typed accross the screen. On most systems
the text is refreshed so fast we only see a flicker.

Cleaning the registry still slow... Profiler shows DML and GHost lines that
appear to suck the life out my system, but its only pegged at 2%, like it's
doing something, but what(?)

Tonight I may have to reformat and reload, however I've seen this before and
would really like a clue.

JeffP...

[JeffP]

Gee,

Found Trace Logging was on in ODBC, had to reg hack Trace to 0. Found Vista as 0. Espannol?

Anyway that cured.


------------
JeffP at 12/10/2001 3:20:03 PM


MSSQL .7.0 SP2
WIN2KPRO
ATI 32mb video
1.3gh AMD
1g Ram

No other apps are affected....my once fast system is slowed to a crawl. 5+gb
free on C 37gb on E and NO apps loaded in systray. NO background processes,
nunca.

I installed MDAC 2.6 on a system to try to correct an OLE error when using
sp_OACreate that causes an ODBC connection broken and shuts down SQL every
other execution.

***** Now, the system is running slow, I tried reinstalling, moving the data
to a single local drive. (No other apps appear to be slowed)

Uninstalled MDAC 2.6 and reverted to 2.5 still slow.

Reinstalling MSSQL 7 and SP2, and MDAC 2.5 still slow...

As an example, when a simple xp_cmdShell 'dir c:mssql7data*data.mdf' the
resulting 10 lines are slowing typed accross the screen. On most systems
the text is refreshed so fast we only see a flicker.

Cleaning the registry still slow... Profiler shows DML and GHost lines that
appear to suck the life out my system, but its only pegged at 2%, like it's
doing something, but what(?)

Tonight I may have to reformat and reload, however I've seen this before and
would really like a clue.

JeffP...