Collect SQL Server/Process Information

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Rudy Panigas » Collect SQL Server/Process Information -...

11 posts, Page 1 of 2

1 2 »»

Collect SQL Server/Process Information - Quickly

Rate Topic

Display Mode

Topic Options

Author

Message

Rudy Panigas

Posted Wednesday, September 09, 2009 9:20 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 5:32 PM
Points: 306, Visits: 1,013

Comments posted to this topic are about the item Collect SQL Server/Process Information - Quickly

Post #785088

Randall Hernandez Araya

Posted Saturday, September 26, 2009 11:22 AM

Grasshopper

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

Rudy Panigas

Posted Monday, September 28, 2009 6:18 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 5:32 PM
Points: 306, Visits: 1,013

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

Rudy Panigas

Posted Monday, September 28, 2009 6:38 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 5:32 PM
Points: 306, Visits: 1,013

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

thorkw

Posted Thursday, April 21, 2011 7:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 05, 2013 9:14 AM
Points: 6, Visits: 176

quick question: when do the numbers get reset, on a stop/start of Sql Server? or a reboot of the machine?

Post #1096982

chuck.moore

Posted Thursday, April 21, 2011 7:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:44 AM
Points: 8, Visits: 141

All I get is commands completed successfully.

Post #1096986

thorkw

Posted Thursday, April 21, 2011 7:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 05, 2013 9:14 AM
Points: 6, Visits: 176

where do you have your "Query Results" pointing to???

Post #1096993

Rudy Panigas

Posted Thursday, April 21, 2011 7:50 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 5:32 PM
Points: 306, Visits: 1,013

The results are display on the screen once you execute the stored procedure.

Thanks,

Rudy

Post #1097005

chuck.moore

Posted Thursday, April 21, 2011 7:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:44 AM
Points: 8, Visits: 141

Query results to Grid.

Post #1097015

thorkw

Posted Thursday, April 21, 2011 8:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 05, 2013 9:14 AM
Points: 6, Visits: 176

@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 »

11 posts, Page 1 of 2

1 2 »»

Permissions