Friday, March 23, 2012

mmc.exe writes a lot to SQL.LOG when working with Enterprise Manag

I noticed that mmc.exe wrote a lot of information to SQL.LOG file, which was
generated by mmc.exe, when I was working with Enterprise Manager. For
instance, a double-click a database name or the server name would write abou
t
330K to the file. Thus, I had to wait for about 40 seconds per click. It
happended only on my Windows 2000 Server (SP4). Other servers do not even
generate the file. The following is sample of information written to the fil
e:
sqlstp 17c-840 ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 00794460
Any idea about it? How to turn off it? Thanks.I found a solution: Turning off ODBC tracing. It's the ODBC tracing that
writes trace to the file.
"Kathy" wrote:

> I noticed that mmc.exe wrote a lot of information to SQL.LOG file, which w
as
> generated by mmc.exe, when I was working with Enterprise Manager. For
> instance, a double-click a database name or the server name would write ab
out
> 330K to the file. Thus, I had to wait for about 40 seconds per click. It
> happended only on my Windows 2000 Server (SP4). Other servers do not even
> generate the file. The following is sample of information written to the f
ile:
> sqlstp 17c-840 ENTER SQLAllocHandle
> SQLSMALLINT 1 <SQL_HANDLE_ENV>
> SQLHANDLE 00000000
> SQLHANDLE * 00794460
> Any idea about it? How to turn off it? Thanks.
>

No comments:

Post a Comment