I am to install MMC 3.0 to a server (Server 2003 Standard Edition SP1) with
SQL 2000 Sp4. I would like to know if Server Enterprise Manager works under
MMC 3.0.
--
Regards
Rasmus SöderlundHi Rasmus
EM seems to work fine with MMC 3.0
John
"Rasmus" wrote:
> I am to install MMC 3.0 to a server (Server 2003 Standard Edition SP1) with
> SQL 2000 Sp4. I would like to know if Server Enterprise Manager works under
> MMC 3.0.
> --
> Regards
>
> Rasmus Söderlund
Showing posts with label sp1. Show all posts
Showing posts with label sp1. Show all posts
Wednesday, March 21, 2012
Wednesday, March 7, 2012
Missing Perf Counters
I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!
Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/FA...rCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||See below URLS as well.
http://sql-server-performance.com/fo...p?TOPIC_ID=695
http://sql-server-performance.com/fo...p?TOPIC_ID=308
http://sql-server-performance.com/fo...p?TOPIC_ID=687
http://sql-server-performance.com/fo...p?TOPIC_ID=907
http://sql-server-performance.com/fo...p?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!
Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/FA...rCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||See below URLS as well.
http://sql-server-performance.com/fo...p?TOPIC_ID=695
http://sql-server-performance.com/fo...p?TOPIC_ID=308
http://sql-server-performance.com/fo...p?TOPIC_ID=687
http://sql-server-performance.com/fo...p?TOPIC_ID=907
http://sql-server-performance.com/fo...p?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>
Missing Perf Counters
I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||See below URLS as well.
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=695
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=308
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=687
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=907
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||See below URLS as well.
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=695
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=308
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=687
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=907
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>
Missing Perf Counters
I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/F...erCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||See below URLS as well.
http://sql-server-performance.com/f...sp?TOPIC_ID=695
http://sql-server-performance.com/f...sp?TOPIC_ID=308
http://sql-server-performance.com/f...sp?TOPIC_ID=687
http://sql-server-performance.com/f...sp?TOPIC_ID=907
http://sql-server-performance.com/f...sp?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I canno
t
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/F...erCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||See below URLS as well.
http://sql-server-performance.com/f...sp?TOPIC_ID=695
http://sql-server-performance.com/f...sp?TOPIC_ID=308
http://sql-server-performance.com/f...sp?TOPIC_ID=687
http://sql-server-performance.com/f...sp?TOPIC_ID=907
http://sql-server-performance.com/f...sp?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I canno
t
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>
Monday, February 20, 2012
Missing Feature in SP2 "Database Mirror Monitor"
Hello,
http://img83.imageshack.us/img83/2783/missingdbmirrormonitorht0.jpg
any ideas?
I've been running SQL 2005 Enterprise SP1 for some time. After installing SP2, I miss the "Database Mirror Monitor"-Feature. Where is it? Did MS kill the feature?
regards
alejandroo
I'm running SP2 and for me it's located in SQL Server Management Studio
- Right-click the database in Object Explorer
- click 'Tasks'
- click 'Launch database mirroring monitor'
|||I know where to find it, but it isn't there... see the screenshot:http://img83.imageshack.us/img83/2783/missingdbmirrormonitorht0.jpg
any ideas?
regards
alejanndroo|||Maybe try installing the English version of the client tools? Maybe it was overlooked in your localized version? I dunno...|||Thanks for the hint, I'll give it a try...
|||Database mirror monitor is only available on the standard and enterprise editions of sql server 2005 only. If you are connected to any other version of sql, this tool is not available.|||
Fyi, appearance of the monitor depends on whether a database is selected. When you open the monitor, the detail pane displays a Register mirrored database link. Click this to register a database. Registered databases are listed below the Database Mirroring Monitor node in the navigation tree. Database Mirroring Monitor always tries to connect to every server instance for which it has stored credentials.
Missing Feature in SP2 "Database Mirror Monitor"
Hello,
http://img83.imageshack.us/img83/2783/missingdbmirrormonitorht0.jpg
any ideas?
I've been running SQL 2005 Enterprise SP1 for some time. After installing SP2, I miss the "Database Mirror Monitor"-Feature. Where is it? Did MS kill the feature?
regards
alejandroo
I'm running SP2 and for me it's located in SQL Server Management Studio
- Right-click the database in Object Explorer
- click 'Tasks'
- click 'Launch database mirroring monitor'
|||I know where to find it, but it isn't there... see the screenshot:http://img83.imageshack.us/img83/2783/missingdbmirrormonitorht0.jpg
any ideas?
regards
alejanndroo|||Maybe try installing the English version of the client tools? Maybe it was overlooked in your localized version? I dunno...|||Thanks for the hint, I'll give it a try...
|||Database mirror monitor is only available on the standard and enterprise editions of sql server 2005 only. If you are connected to any other version of sql, this tool is not available.|||
Fyi, appearance of the monitor depends on whether a database is selected. When you open the monitor, the detail pane displays a Register mirrored database link. Click this to register a database. Registered databases are listed below the Database Mirroring Monitor node in the navigation tree. Database Mirroring Monitor always tries to connect to every server instance for which it has stored credentials.
Subscribe to:
Posts (Atom)