Red Gate forums :: View topic - Permon counter questions
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Permon counter questions

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
toad2898



Joined: 14 Sep 2009
Posts: 26

PostPosted: Thu Sep 05, 2013 2:40 pm    Post subject: Permon counter questions Reply with quote

Hi. I'm trying SQL Monitor out for our company (approx 50 VMs running SQL 2000 through 2012).

As we run vmware and even though they're obviously not SQL counters I would normally monitor various counters under the VM Processor and VM Memory categories.

I see you can create custom metrics but these appear to have to be t-sql based and these counters aren't ever likely to appear in sys.dm_os_performance_counters Very Happy

Is there a way to include additional machine level perfmon counters without using t-sql?

Thanks
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Mon Sep 09, 2013 7:51 am    Post subject: Reply with quote

I am the support engineer that is responding to this support request. The forum post has raised a support ticket in our ticketing system and I am following up in regards to this issue.

I have responded to this via our ticketing system for your reference.

Are you able to let me know how many licenses of SQL Monitor you are planning to use to monitor this environment?

Thanks for your interest in our product.
Back to top
View user's profile Send private message
toad2898



Joined: 14 Sep 2009
Posts: 26

PostPosted: Mon Sep 09, 2013 8:53 am    Post subject: Reply with quote

Hi. If the ticketing system response you mention was sent to me via e-mail could you send it again as the address on my profile was out of date.

betweeen 20 and 40 servers.

thanks
Back to top
View user's profile Send private message
toad2898



Joined: 14 Sep 2009
Posts: 26

PostPosted: Fri Sep 13, 2013 8:21 am    Post subject: Reply with quote

Hi. Would it possible to get an answer to this soon? It's just my trial runs out in 5 days, 2 of which I won't be working. Thanks.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri Sep 13, 2013 1:07 pm    Post subject: Reply with quote

Hi Rob,

Apologies for the delay. We assumed that you received our reply email. You should be able to do this using xp_cmdshell. I have just quickly put an example together.

Code:
IF OBJECT_ID('tempdb..#ProcessorTime') IS NOT NULL
    DROP TABLE #ProcessorTime

CREATE TABLE #ProcessorTime
    (
      RowID INT IDENTITY(1, 1) ,
      Value VARCHAR(255)
    )

INSERT  INTO #ProcessorTime
        EXEC xp_cmdshell 'typeperf "\processor(_Total)\% Processor Time" -sc 1'


IF NOT EXISTS ( SELECT  1
                FROM    #ProcessorTime
                WHERE   Value LIKE '%Error%' )
    BEGIN
        SELECT  CAST(REPLACE(RIGHT(Value, LEN(Value) - CHARINDEX(',', Value)),
                             '"', '') AS FLOAT)  AS ProcessorTime
        FROM    #ProcessorTime
        WHERE   RowID = 3
    END
ELSE
    BEGIN
        SELECT  -1 AS ProcessorTime
    END

DROP TABLE #ProcessorTime


It is not tested properly so please verify it before you actually use this. Also, if you need to extend your trial then just drop us a line and we would be happy to help you with trial extension.

Thanks,
Priya
Back to top
View user's profile Send private message
toad2898



Joined: 14 Sep 2009
Posts: 26

PostPosted: Tue Sep 17, 2013 3:00 pm    Post subject: Reply with quote

Thanks Priya.

Here is some feedback.

It does work, I've tested it but it's better for some counters than others, if I can explain:

To add disk level counters, for example PhysicalDisk > Disk Writes/sec. I'd have to set up a separate custom metric for every disk on every server which isn't managable as in my case I'm going to end up with hundreds of custom metrics and you kind of buy these tools so you don't have to do stuff like that.

in addition to that, the show: box under the analysis graph is too small to display the full metric name unless you hover on it which means you always have to think up clever short names for perfmon counters with long ones.

and then there's the use of xp_cmdshell and all the debate that comes along with enabling it.

I guess to summarise it would be:- please can you please put more machine metrics into the core product.

Overall I like the product though and i understand it's not just written for me is it!

Thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group