InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:06:22 GMT20http://www.sqlservercentral.com/Forums/Topic785088-471-1.aspx[quote][b]thorkw (4/21/2011)[/b][hr]@Rudy: Sorry, but I can't find an answer to my question above, in BOL.When do the numbers get reset, on a stop/start of Sql Server? or a reboot of the machine? thanks, Bill.[/quote]Bill, once you restart the SQL server services or reboot the server the numbers will be reset. You can also reset them with certain DMV. Not sure which ones will do that (off the top of my head). You can just google it. Also, you could go to www.sqlskill.com as Paul Randal will have the answer. I will have a look and post them later.Thanks,RudyThu, 21 Apr 2011 09:24:12 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspx@Rudy: Sorry, but I can't find an answer to my question above, in BOL.When do the numbers get reset, on a stop/start of Sql Server? or a reboot of the machine? thanks, Bill.Thu, 21 Apr 2011 08:35:18 GMTthorkwhttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspxQuery results to Grid.Thu, 21 Apr 2011 07:57:59 GMTchuck.moorehttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspxThe results are display on the screen once you execute the stored procedure.Thanks,RudyThu, 21 Apr 2011 07:50:07 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspxwhere do you have your "Query Results" pointing to???Thu, 21 Apr 2011 07:41:17 GMTthorkwhttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspxAll I get is commands completed successfully.Thu, 21 Apr 2011 07:38:24 GMTchuck.moorehttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspxquick question: when do the numbers get reset, on a stop/start of Sql Server? or a reboot of the machine?Thu, 21 Apr 2011 07:32:49 GMTthorkwhttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspxHello again,Just ran the complete script on a SQL 2008 with SP1 and there was no problem with that DMV. You should check to see if you have permission to the views.That's all I can thing of right now.RudyMon, 28 Sep 2009 06:38:47 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspxHello,No this table is not generated and actually it's not a table but a view. I haven't looked for it in SQL 2008 but check Books On Line (BOL) and see if MS has changed the name, removed it or uses a different view to collect the information.Sorry that I don't have the answer just yet.Thanks,RuidyMon, 28 Sep 2009 06:18:16 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspxHi have one question, the scrip cannot be execute because I my SQL Server 2008 I don't have the table sys.dm_os_performance_counters Is this table generate by another process?Sat, 26 Sep 2009 11:22:22 GMTRandall Hernandez Arayahttp://www.sqlservercentral.com/Forums/Topic785088-471-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Monitoring/68069/">Collect SQL Server/Process Information - Quickly</A>[/B]Wed, 09 Sep 2009 09:20:28 GMTRudy Panigas