April 28, 2005 at 11:50 am
Hello,
I need to reset a counter on the sysperfinfo system table after an alert is fired. I do not want to perform adhoc updates. Is there an indirect way or a system stored procedure in sql 2000 to do this ?
Thanks
April 28, 2005 at 3:04 pm
I don't believe that you can do this.
April 29, 2005 at 12:01 am
sysperfinfo is a fake table. That is an in-memory structure that only materializes in tabular form when queried. As Steve already said, I don't think you can do this.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 29, 2005 at 7:54 am
Thanks for your reply. It is possible to do it indirectly using sp_user_counter.
For eg exec sp_user_counter1 <parameter value>
April 29, 2005 at 9:10 am
Well, yes, specifically for setting the user-defined counters that can be monitored using System Monitor. You did not mention if it was those counters you were asking about in your original post.
May 2, 2005 at 1:01 am
Yes, that sounds now a bit different from your original question. At least as I have understood it. Anyway, for sp_user_counter, I guess you have had a look at BOL for "User Settable Object"?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 11:17 am
DBCC setinstance (objectname, countername, instancename, value)
hth
* Noel
May 3, 2005 at 12:44 am
DBCC SETINSTANCE is undocumented and basically only the underlying call behind the sp_user_counter procs.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply