Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Collect SQL Server/Process Information - Quickly Expand / Collapse
Author
Message
Posted Wednesday, September 9, 2009 9:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 1:19 PM
Points: 318, Visits: 1,127
Comments posted to this topic are about the item Collect SQL Server/Process Information - Quickly


Post #785088
Posted Saturday, September 26, 2009 11:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 25, 2010 11:53 PM
Points: 10, Visits: 5
Hi 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?
Post #794178
Posted Monday, September 28, 2009 6:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 1:19 PM
Points: 318, Visits: 1,127
Hello,

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,

Ruidy



Post #794458
Posted Monday, September 28, 2009 6:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 1:19 PM
Points: 318, Visits: 1,127
Hello 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.

Rudy



Post #794465
Posted Thursday, April 21, 2011 7:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 19, 2014 7:15 AM
Points: 7, Visits: 190
quick question: when do the numbers get reset, on a stop/start of Sql Server? or a reboot of the machine?
Post #1096982
Posted Thursday, April 21, 2011 7:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 8:52 AM
Points: 8, Visits: 167
All I get is commands completed successfully.
Post #1096986
Posted Thursday, April 21, 2011 7:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 19, 2014 7:15 AM
Points: 7, Visits: 190
where do you have your "Query Results" pointing to???
Post #1096993
Posted Thursday, April 21, 2011 7:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 1:19 PM
Points: 318, Visits: 1,127
The results are display on the screen once you execute the stored procedure.

Thanks,

Rudy



Post #1097005
Posted Thursday, April 21, 2011 7:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 8:52 AM
Points: 8, Visits: 167
Query results to Grid.
Post #1097015
Posted Thursday, April 21, 2011 8:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 19, 2014 7:15 AM
Points: 7, Visits: 190
@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.
Post #1097043
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse