Dear all,
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...[vbcol=seagreen]
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...][vbcol=seagreen]
> Dan Guzman
> SQL Server MVP
>
Dan,
Thank you for your help!
Best regards,
Andrew
Showing posts with label monitor. Show all posts
Showing posts with label monitor. Show all posts
Monday, March 19, 2012
[SQL Server 2000] How to programmatically read Merge Agent properties
Dear all,
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
>> Try a profiler trace and examine the source of the executed procs.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...]
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Ok, I've checked, but unfortunately that is an undocumented procedure:
>> sp_MSenum_replication_agents @.type = 4
>> (type = 4 stands for merge replication agent)
Dan,
Thank you for your help!
Best regards,
Andrew
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
>> Try a profiler trace and examine the source of the executed procs.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...]
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Ok, I've checked, but unfortunately that is an undocumented procedure:
>> sp_MSenum_replication_agents @.type = 4
>> (type = 4 stands for merge replication agent)
Dan,
Thank you for your help!
Best regards,
Andrew
Thursday, February 9, 2012
@@IDLE Bug?
I have written a custom monitor, similar to sp_monitor that stores the
values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
I have observed that the value of @.@.idle prematurely wraps to a negative
number. Since this value is comprised of a 4 byte integer, one would expect
the value to wrap around to a negative value when it reaches 2,147,483,647.
However, my observations show that this value is wrapping at a value
somewhere just over 441150174 to a negative value somewhere just
under -95648727.
Does anyone have any insight as to why this system variable is prematurely
wrapping? What are the exact values that @.@.idle wraps at?Does anyone have insight into the SQL internals on how the @.@.idle value
rolls over?
"Don Ferguson" <don@.nospamplease> wrote in message
news:uyi0lQLhEHA.1724@.tk2msftngp13.phx.gbl...
> I have written a custom monitor, similar to sp_monitor that stores the
> values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
> I have observed that the value of @.@.idle prematurely wraps to a negative
> number. Since this value is comprised of a 4 byte integer, one would
expect
> the value to wrap around to a negative value when it reaches
2,147,483,647.
> However, my observations show that this value is wrapping at a value
> somewhere just over 441150174 to a negative value somewhere just
> under -95648727.
> Does anyone have any insight as to why this system variable is prematurely
> wrapping? What are the exact values that @.@.idle wraps at?
>
values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
I have observed that the value of @.@.idle prematurely wraps to a negative
number. Since this value is comprised of a 4 byte integer, one would expect
the value to wrap around to a negative value when it reaches 2,147,483,647.
However, my observations show that this value is wrapping at a value
somewhere just over 441150174 to a negative value somewhere just
under -95648727.
Does anyone have any insight as to why this system variable is prematurely
wrapping? What are the exact values that @.@.idle wraps at?Does anyone have insight into the SQL internals on how the @.@.idle value
rolls over?
"Don Ferguson" <don@.nospamplease> wrote in message
news:uyi0lQLhEHA.1724@.tk2msftngp13.phx.gbl...
> I have written a custom monitor, similar to sp_monitor that stores the
> values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
> I have observed that the value of @.@.idle prematurely wraps to a negative
> number. Since this value is comprised of a 4 byte integer, one would
expect
> the value to wrap around to a negative value when it reaches
2,147,483,647.
> However, my observations show that this value is wrapping at a value
> somewhere just over 441150174 to a negative value somewhere just
> under -95648727.
> Does anyone have any insight as to why this system variable is prematurely
> wrapping? What are the exact values that @.@.idle wraps at?
>
@@IDLE Bug?
I have written a custom monitor, similar to sp_monitor that stores the
values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
I have observed that the value of @.@.idle prematurely wraps to a negative
number. Since this value is comprised of a 4 byte integer, one would expect
the value to wrap around to a negative value when it reaches 2,147,483,647.
However, my observations show that this value is wrapping at a value
somewhere just over 441150174 to a negative value somewhere just
under -95648727.
Does anyone have any insight as to why this system variable is prematurely
wrapping? What are the exact values that @.@.idle wraps at?
Does anyone have insight into the SQL internals on how the @.@.idle value
rolls over?
"Don Ferguson" <don@.nospamplease> wrote in message
news:uyi0lQLhEHA.1724@.tk2msftngp13.phx.gbl...
> I have written a custom monitor, similar to sp_monitor that stores the
> values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
> I have observed that the value of @.@.idle prematurely wraps to a negative
> number. Since this value is comprised of a 4 byte integer, one would
expect
> the value to wrap around to a negative value when it reaches
2,147,483,647.
> However, my observations show that this value is wrapping at a value
> somewhere just over 441150174 to a negative value somewhere just
> under -95648727.
> Does anyone have any insight as to why this system variable is prematurely
> wrapping? What are the exact values that @.@.idle wraps at?
>
values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
I have observed that the value of @.@.idle prematurely wraps to a negative
number. Since this value is comprised of a 4 byte integer, one would expect
the value to wrap around to a negative value when it reaches 2,147,483,647.
However, my observations show that this value is wrapping at a value
somewhere just over 441150174 to a negative value somewhere just
under -95648727.
Does anyone have any insight as to why this system variable is prematurely
wrapping? What are the exact values that @.@.idle wraps at?
Does anyone have insight into the SQL internals on how the @.@.idle value
rolls over?
"Don Ferguson" <don@.nospamplease> wrote in message
news:uyi0lQLhEHA.1724@.tk2msftngp13.phx.gbl...
> I have written a custom monitor, similar to sp_monitor that stores the
> values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
> I have observed that the value of @.@.idle prematurely wraps to a negative
> number. Since this value is comprised of a 4 byte integer, one would
expect
> the value to wrap around to a negative value when it reaches
2,147,483,647.
> However, my observations show that this value is wrapping at a value
> somewhere just over 441150174 to a negative value somewhere just
> under -95648727.
> Does anyone have any insight as to why this system variable is prematurely
> wrapping? What are the exact values that @.@.idle wraps at?
>
@@IDLE Bug?
I have written a custom monitor, similar to sp_monitor that stores the
values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
I have observed that the value of @.@.idle prematurely wraps to a negative
number. Since this value is comprised of a 4 byte integer, one would expect
the value to wrap around to a negative value when it reaches 2,147,483,647.
However, my observations show that this value is wrapping at a value
somewhere just over 441150174 to a negative value somewhere just
under -95648727.
Does anyone have any insight as to why this system variable is prematurely
wrapping? What are the exact values that @.@.idle wraps at?Does anyone have insight into the SQL internals on how the @.@.idle value
rolls over?
"Don Ferguson" <don@.nospamplease> wrote in message
news:uyi0lQLhEHA.1724@.tk2msftngp13.phx.gbl...
> I have written a custom monitor, similar to sp_monitor that stores the
> values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
> I have observed that the value of @.@.idle prematurely wraps to a negative
> number. Since this value is comprised of a 4 byte integer, one would
expect
> the value to wrap around to a negative value when it reaches
2,147,483,647.
> However, my observations show that this value is wrapping at a value
> somewhere just over 441150174 to a negative value somewhere just
> under -95648727.
> Does anyone have any insight as to why this system variable is prematurely
> wrapping? What are the exact values that @.@.idle wraps at?
>
values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
I have observed that the value of @.@.idle prematurely wraps to a negative
number. Since this value is comprised of a 4 byte integer, one would expect
the value to wrap around to a negative value when it reaches 2,147,483,647.
However, my observations show that this value is wrapping at a value
somewhere just over 441150174 to a negative value somewhere just
under -95648727.
Does anyone have any insight as to why this system variable is prematurely
wrapping? What are the exact values that @.@.idle wraps at?Does anyone have insight into the SQL internals on how the @.@.idle value
rolls over?
"Don Ferguson" <don@.nospamplease> wrote in message
news:uyi0lQLhEHA.1724@.tk2msftngp13.phx.gbl...
> I have written a custom monitor, similar to sp_monitor that stores the
> values of @.@.cpu_busy, @.@.io_busy, @.@.idle, etc... to a table.
> I have observed that the value of @.@.idle prematurely wraps to a negative
> number. Since this value is comprised of a 4 byte integer, one would
expect
> the value to wrap around to a negative value when it reaches
2,147,483,647.
> However, my observations show that this value is wrapping at a value
> somewhere just over 441150174 to a negative value somewhere just
> under -95648727.
> Does anyone have any insight as to why this system variable is prematurely
> wrapping? What are the exact values that @.@.idle wraps at?
>
Subscribe to:
Posts (Atom)