Tuesday, March 20, 2012
can't see SQL server objects and counters on performance monitor
on performance monitor.
does anybody have the same situation?
ThanksHi
Do you mean that if you click on Performance object's combobox you don't see
SQL Server counters?
"chacha" <lichangang@.hotmail.com> wrote in message
news:FF74189B-EDFD-4C8A-96AF-260F11BD49CE@.microsoft.com...
>I installed SQL server 2005 on Windows XP sp2, but I can't see SQL counters
> on performance monitor.
> does anybody have the same situation?
> Thanks|||This can happen sometimes. The main reason that it causes it is that
by the time that you run perfmon with SQL Server's counters, you stop
the server's service. Few years ago I found the procedure bellow to
get the counters back (Sorry that I don't give credit, but I don't
remember where I got it from). I always start from step 4. I never
needed to run the first 3 steps.
1. You have full permission to access the local folder: C:\Program
Files\Microsoft SQL Server\MSSQL
Make sure that you can access this folder or your current account is
located in local administrator group.
2. Make sure there is no third-party application which add keys in
Register to disable the performance counters.
You can open the registry to check if there is a key named "Disable
Performance Counters" valued "1" in:
& #91;HKEY_LOCAL_MACHINE\SYSTEM\CurrentCon
trolSet\Services\MSSQLSERVER\Perfor
mance]
If it exists, please delete it
3. Under the register key:
& #91;HKEY_LOCAL_MACHINE\SYSTEM\CurrentCon
trolSet\Services\MSSQLSERVER\Perfor
mance]
Make sure the following keys with the value DO EXIST. If not, please
create
a new one and add the value.
# Note # : The "Last Counter", "Last Help", "First Help",
"WbemAdapFileSignature",
"WbemAdapFileTime", and "First Counter" values can vary between SQL
Server
installations.
"Library"=" C:\PROGRA~1\MICROS~3\MSSQL$~1\BINN\SQLCT
R80.DLL "
"Collect"="CollectSQLPerformanceData"
"Open"="OpenSQLPerformanceData"
"Close"="CloseSQLPerformanceData"
"Last Counter"=dword:000016ce
"Last Help"=dword:000016cf
"First Help"=dword:000015bb
"WbemAdapFileSignature" =hex:d1,70,dc,f8,a7,75,5e,e4,9e,e6,dd,91
,9e,cd,06,65
"WbemAdapFileTime"=hex:d6,34,9d,95,64,0d,c2,01
"WbemAdapFileSize"=dword:00008238
"WbemAdapStatus"=dword:00000000
"First Counter"=dword:000015ba
4. Unload the SQL Server Counters
In command line, execute "unlodctr MSSQLServer" (Without quotation, the
same as below)
5. Reloading the SQL Server Counters
(1) In command line, locate the current folder to C:\Program
Files\Microsoft SQL Server\MSSQL\BINN
(2) Execute "lodctr sqlctr.ini"
6. Stop SQL Server Services and Restart the Services
(1) In command line, execute "net stop mssqlserver"
(2) Execute "net start mssqlserver"
(Or you can perform it in Service Manager or in System Services)
7. Open Perforam Monitor to check if the counters appear
(1) In command line, execute "perfmon"
(2) Add and check if the counter appear
Adi
chacha wrote:
> I installed SQL server 2005 on Windows XP sp2, but I can't see SQL counter
s
> on performance monitor.
> does anybody have the same situation?
> Thanks
can't see SQL server objects and counters on performance monitor
on performance monitor.
does anybody have the same situation?
ThanksHi
Do you mean that if you click on Performance object's combobox you don't see
SQL Server counters?
"chacha" <lichangang@.hotmail.com> wrote in message
news:FF74189B-EDFD-4C8A-96AF-260F11BD49CE@.microsoft.com...
>I installed SQL server 2005 on windows Xp sp2, but I can't see SQL counters
> on performance monitor.
> does anybody have the same situation?
> Thanks|||This can happen sometimes. The main reason that it causes it is that
by the time that you run perfmon with SQL Server's counters, you stop
the server's service. Few years ago I found the procedure bellow to
get the counters back (Sorry that I don't give credit, but I don't
remember where I got it from). I always start from step 4. I never
needed to run the first 3 steps.
1. You have full permission to access the local folder: C:\Program
Files\Microsoft SQL Server\MSSQL
Make sure that you can access this folder or your current account is
located in local administrator group.
2. Make sure there is no third-party application which add keys in
Register to disable the performance counters.
You can open the registry to check if there is a key named "Disable
Performance Counters" valued "1" in:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]
If it exists, please delete it
3. Under the register key:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]
Make sure the following keys with the value DO EXIST. If not, please
create
a new one and add the value.
# Note # : The "Last Counter", "Last Help", "First Help",
"WbemAdapFileSignature",
"WbemAdapFileTime", and "First Counter" values can vary between SQL
Server
installations.
"Library"=" C:\PROGRA~1\MICROS~3\MSSQL$~1\BINN\SQLCTR80.DLL "
"Collect"="CollectSQLPerformanceData"
"Open"="OpenSQLPerformanceData"
"Close"="CloseSQLPerformanceData"
"Last Counter"=dword:000016ce
"Last Help"=dword:000016cf
"First Help"=dword:000015bb
"WbemAdapFileSignature"=hex:d1,70,dc,f8,a7,75,5e,e4,9e,e6,dd,91,9e,cd,06,65
"WbemAdapFileTime"=hex:d6,34,9d,95,64,0d,c2,01
"WbemAdapFileSize"=dword:00008238
"WbemAdapStatus"=dword:00000000
"First Counter"=dword:000015ba
4. Unload the SQL Server Counters
In command line, execute "unlodctr MSSQLServer" (Without quotation, the
same as below)
5. Reloading the SQL Server Counters
(1) In command line, locate the current folder to C:\Program
Files\Microsoft SQL Server\MSSQL\BINN
(2) Execute "lodctr sqlctr.ini"
6. Stop SQL Server Services and Restart the Services
(1) In command line, execute "net stop mssqlserver"
(2) Execute "net start mssqlserver"
(Or you can perform it in Service Manager or in System Services)
7. Open Perforam Monitor to check if the counters appear
(1) In command line, execute "perfmon"
(2) Add and check if the counter appear
Adi
chacha wrote:
> I installed SQL server 2005 on windows Xp sp2, but I can't see SQL counters
> on performance monitor.
> does anybody have the same situation?
> Thankssql
Monday, March 19, 2012
Can''t see 64-bit FTS performance counters from 32-bit application
Windows cannot open the 64-bit extensible counter DLL msftesqlFD in a 32-bit environment. Contact the file vendor to obtain a 32-bit version. Alternatively if you are running a 64-bit native environment, you can open the 64-bit extensible counter DLL by using the 64-bit version of Performance Monitor. To use this tool, open the Windows folder, open the System32 folder, and then start Perfmon.exe.
Does Microsoft make available 32-bit counter libraries for 32-bit clients of the 64-bit FTS? How do I obtain those bits?
.B ekiM
Are 32-bit applications not supported by 64-bit servers?
Can''t see 64-bit FTS performance counters from 32-bit application
Windows cannot open the 64-bit extensible counter DLL msftesqlFD in a 32-bit environment. Contact the file vendor to obtain a 32-bit version. Alternatively if you are running a 64-bit native environment, you can open the 64-bit extensible counter DLL by using the 64-bit version of Performance Monitor. To use this tool, open the Windows folder, open the System32 folder, and then start Perfmon.exe.
Does Microsoft make available 32-bit counter libraries for 32-bit clients of the 64-bit FTS? How do I obtain those bits?
.B ekiM
Are 32-bit applications not supported by 64-bit servers?
Saturday, February 25, 2012
can't open an .msc file to monitor SQL server on another machine
but simply copying the .msc file I use to this machine and trying to open it
isn't working. I get this error message:
MMC cannot open the selected file
If it matters, the problelm machine is Windows 2000 and mine is XP.
I thought that I might need to just open MMC and create a new .msc but it's
been so long I can't really remember how to do it at all!
Need some help here...
Paul
That is not how Enterprise Manager work. You need to install the client tools on the client machine
where you want to run Enterprise Manager. You then, on that client machine, register the SQL Servers
you want to work against.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
>I need to be able to monitor our SQL server's performance on a new machine
> but simply copying the .msc file I use to this machine and trying to open it
> isn't working. I get this error message:
> MMC cannot open the selected file
> If it matters, the problelm machine is Windows 2000 and mine is XP.
> I thought that I might need to just open MMC and create a new .msc but it's
> been so long I can't really remember how to do it at all!
> Need some help here...
> Paul
>
|||Already did that.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> That is not how Enterprise Manager work. You need to install the client
tools on the client machine
> where you want to run Enterprise Manager. You then, on that client
machine, register the SQL Servers
> you want to work against.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
machine[vbcol=seagreen]
open it[vbcol=seagreen]
it's
>
|||Then why the need to transfer the msc file? What purpose would that serve? Perhaps I'm
misunderstanding what you want to achieve?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> Already did that.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> tools on the client machine
> machine, register the SQL Servers
> news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
> machine
> open it
> it's
>
|||I have a monitor that graphs SQL Server access methods, processor time, disk
access, and some other stuff in real time through MMC. It's useful to see
what's happening at a glance.
I solved it, though. I needed to manually add the ActiveX control "System
Monitor Control", and I have recreate everything - SQL Server access
methods, system stats, etc (which was a pain). I guess in this case saved
MSC files are not designed to be portable.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Then why the need to transfer the msc file? What purpose would that serve?
Perhaps I'm
> misunderstanding what you want to achieve?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
in[vbcol=seagreen]
but
>
|||I see, you are talking about performance monitor, not Enterprise Manager. Sorry, I haven't used
perfmon enough to know whether the msc file is portable and if so between which OS versions etc.
Consider posting this to a windows group (as perfmon is a windows tool) if the need arises again.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:%23dLuD1skFHA.576@.tk2msftngp13.phx.gbl...
>I have a monitor that graphs SQL Server access methods, processor time, disk
> access, and some other stuff in real time through MMC. It's useful to see
> what's happening at a glance.
> I solved it, though. I needed to manually add the ActiveX control "System
> Monitor Control", and I have recreate everything - SQL Server access
> methods, system stats, etc (which was a pain). I guess in this case saved
> MSC files are not designed to be portable.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Perhaps I'm
> news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> in
> but
>
can't open an .msc file to monitor SQL server on another machine
but simply copying the .msc file I use to this machine and trying to open it
isn't working. I get this error message:
MMC cannot open the selected file
If it matters, the problelm machine is Windows 2000 and mine is XP.
I thought that I might need to just open MMC and create a new .msc but it's
been so long I can't really remember how to do it at all!
Need some help here...
PaulThat is not how Enterprise Manager work. You need to install the client tools on the client machine
where you want to run Enterprise Manager. You then, on that client machine, register the SQL Servers
you want to work against.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
>I need to be able to monitor our SQL server's performance on a new machine
> but simply copying the .msc file I use to this machine and trying to open it
> isn't working. I get this error message:
> MMC cannot open the selected file
> If it matters, the problelm machine is Windows 2000 and mine is XP.
> I thought that I might need to just open MMC and create a new .msc but it's
> been so long I can't really remember how to do it at all!
> Need some help here...
> Paul
>|||Already did that.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> That is not how Enterprise Manager work. You need to install the client
tools on the client machine
> where you want to run Enterprise Manager. You then, on that client
machine, register the SQL Servers
> you want to work against.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
> >I need to be able to monitor our SQL server's performance on a new
machine
> > but simply copying the .msc file I use to this machine and trying to
open it
> > isn't working. I get this error message:
> >
> > MMC cannot open the selected file
> >
> > If it matters, the problelm machine is Windows 2000 and mine is XP.
> >
> > I thought that I might need to just open MMC and create a new .msc but
it's
> > been so long I can't really remember how to do it at all!
> >
> > Need some help here...
> >
> > Paul
> >
> >
>|||Then why the need to transfer the msc file? What purpose would that serve? Perhaps I'm
misunderstanding what you want to achieve?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> Already did that.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
>> That is not how Enterprise Manager work. You need to install the client
> tools on the client machine
>> where you want to run Enterprise Manager. You then, on that client
> machine, register the SQL Servers
>> you want to work against.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Paul" <noone@.executespammers.org> wrote in message
> news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
>> >I need to be able to monitor our SQL server's performance on a new
> machine
>> > but simply copying the .msc file I use to this machine and trying to
> open it
>> > isn't working. I get this error message:
>> >
>> > MMC cannot open the selected file
>> >
>> > If it matters, the problelm machine is Windows 2000 and mine is XP.
>> >
>> > I thought that I might need to just open MMC and create a new .msc but
> it's
>> > been so long I can't really remember how to do it at all!
>> >
>> > Need some help here...
>> >
>> > Paul
>> >
>> >
>|||I have a monitor that graphs SQL Server access methods, processor time, disk
access, and some other stuff in real time through MMC. It's useful to see
what's happening at a glance.
I solved it, though. I needed to manually add the ActiveX control "System
Monitor Control", and I have recreate everything - SQL Server access
methods, system stats, etc (which was a pain). I guess in this case saved
MSC files are not designed to be portable.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Then why the need to transfer the msc file? What purpose would that serve?
Perhaps I'm
> misunderstanding what you want to achieve?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> > Already did that.
> >
> > Paul
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> >> That is not how Enterprise Manager work. You need to install the client
> > tools on the client machine
> >> where you want to run Enterprise Manager. You then, on that client
> > machine, register the SQL Servers
> >> you want to work against.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "Paul" <noone@.executespammers.org> wrote in message
> > news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
> >> >I need to be able to monitor our SQL server's performance on a new
> > machine
> >> > but simply copying the .msc file I use to this machine and trying to
> > open it
> >> > isn't working. I get this error message:
> >> >
> >> > MMC cannot open the selected file
> >> >
> >> > If it matters, the problelm machine is Windows 2000 and mine is XP.
> >> >
> >> > I thought that I might need to just open MMC and create a new .msc
but
> > it's
> >> > been so long I can't really remember how to do it at all!
> >> >
> >> > Need some help here...
> >> >
> >> > Paul
> >> >
> >> >
> >>
> >
> >
>|||I see, you are talking about performance monitor, not Enterprise Manager. Sorry, I haven't used
perfmon enough to know whether the msc file is portable and if so between which OS versions etc.
Consider posting this to a windows group (as perfmon is a windows tool) if the need arises again.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:%23dLuD1skFHA.576@.tk2msftngp13.phx.gbl...
>I have a monitor that graphs SQL Server access methods, processor time, disk
> access, and some other stuff in real time through MMC. It's useful to see
> what's happening at a glance.
> I solved it, though. I needed to manually add the ActiveX control "System
> Monitor Control", and I have recreate everything - SQL Server access
> methods, system stats, etc (which was a pain). I guess in this case saved
> MSC files are not designed to be portable.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
>> Then why the need to transfer the msc file? What purpose would that serve?
> Perhaps I'm
>> misunderstanding what you want to achieve?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Paul" <noone@.executespammers.org> wrote in message
> news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
>> > Already did that.
>> >
>> > Paul
>> >
>> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
>> > message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
>> >> That is not how Enterprise Manager work. You need to install the client
>> > tools on the client machine
>> >> where you want to run Enterprise Manager. You then, on that client
>> > machine, register the SQL Servers
>> >> you want to work against.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >> Blog: http://solidqualitylearning.com/blogs/tibor/
>> >>
>> >>
>> >> "Paul" <noone@.executespammers.org> wrote in message
>> > news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
>> >> >I need to be able to monitor our SQL server's performance on a new
>> > machine
>> >> > but simply copying the .msc file I use to this machine and trying to
>> > open it
>> >> > isn't working. I get this error message:
>> >> >
>> >> > MMC cannot open the selected file
>> >> >
>> >> > If it matters, the problelm machine is Windows 2000 and mine is XP.
>> >> >
>> >> > I thought that I might need to just open MMC and create a new .msc
> but
>> > it's
>> >> > been so long I can't really remember how to do it at all!
>> >> >
>> >> > Need some help here...
>> >> >
>> >> > Paul
>> >> >
>> >> >
>> >>
>> >
>> >
>
can't open an .msc file to monitor SQL server on another machine
but simply copying the .msc file I use to this machine and trying to open it
isn't working. I get this error message:
MMC cannot open the selected file
If it matters, the problelm machine is Windows 2000 and mine is XP.
I thought that I might need to just open MMC and create a new .msc but it's
been so long I can't really remember how to do it at all!
Need some help here...
PaulThat is not how Enterprise Manager work. You need to install the client tool
s on the client machine
where you want to run Enterprise Manager. You then, on that client machine,
register the SQL Servers
you want to work against.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.g
bl...
>I need to be able to monitor our SQL server's performance on a new machine
> but simply copying the .msc file I use to this machine and trying to open
it
> isn't working. I get this error message:
> MMC cannot open the selected file
> If it matters, the problelm machine is Windows 2000 and mine is XP.
> I thought that I might need to just open MMC and create a new .msc but it'
s
> been so long I can't really remember how to do it at all!
> Need some help here...
> Paul
>|||Already did that.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> That is not how Enterprise Manager work. You need to install the client
tools on the client machine
> where you want to run Enterprise Manager. You then, on that client
machine, register the SQL Servers
> you want to work against.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
machine[vbcol=seagreen]
open it[vbcol=seagreen]
it's[vbcol=seagreen]
>|||Then why the need to transfer the msc file? What purpose would that serve? P
erhaps I'm
misunderstanding what you want to achieve?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.g
bl...
> Already did that.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> tools on the client machine
> machine, register the SQL Servers
> news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
> machine
> open it
> it's
>|||I have a monitor that graphs SQL Server access methods, processor time, disk
access, and some other stuff in real time through MMC. It's useful to see
what's happening at a glance.
I solved it, though. I needed to manually add the ActiveX control "System
Monitor Control", and I have recreate everything - SQL Server access
methods, system stats, etc (which was a pain). I guess in this case saved
MSC files are not designed to be portable.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Then why the need to transfer the msc file? What purpose would that serve?
Perhaps I'm
> misunderstanding what you want to achieve?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
in[vbcol=seagreen]
but[vbcol=seagreen]
>|||I see, you are talking about performance monitor, not Enterprise Manager. So
rry, I haven't used
perfmon enough to know whether the msc file is portable and if so between wh
ich OS versions etc.
Consider posting this to a windows group (as perfmon is a windows tool) if t
he need arises again.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:%23dLuD1skFHA.576@.tk2msftngp13.phx.
gbl...
>I have a monitor that graphs SQL Server access methods, processor time, dis
k
> access, and some other stuff in real time through MMC. It's useful to see
> what's happening at a glance.
> I solved it, though. I needed to manually add the ActiveX control "System
> Monitor Control", and I have recreate everything - SQL Server access
> methods, system stats, etc (which was a pain). I guess in this case saved
> MSC files are not designed to be portable.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Perhaps I'm
> news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> in
> but
>