Is there a way i can import the .blg perfmon counter log into a table for
reporting purposesUsing Performance (System) Monitor in Windows 2000 and 2003, you can save
the log to the text file. Then you can use Bulk Insert to copy the data to a
table. I don't remember for Win 2k, but in Win 2003 you can save it even
directly to a SQL table.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#XqypYBfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> Is there a way i can import the .blg perfmon counter log into a table for
> reporting purposes
>|||Since you have the perfmon file in binary format you can pull out the actual
counters you want as csv using win2k resource kit program relog.exe. Then
create a table with the desired structure and bcp it in, or do a DTS import.
If you are running on xp or 2003 you can have perfmon log straight to a sql
server database.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#XqypYBfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> Is there a way i can import the .blg perfmon counter log into a table for
> reporting purposes
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment