February 13, 2015 at 3:18 am
Hi,
SQL Server 2014 BI edition.
select * from sys.dm_os_performance_counters returns the object names prefixed with "SQLServer:" (e.g. SQLServer:Databases)
It was expected as in other editions also. Issue is that when we try to crate "SQLServer Performance Condition alert", object names in "Object" list comes without the prefix "SQLServer:" (e.g. Databases). Please see the attached snapshots.
Anyone has any idea why so ?
This is causing some issues for us as we have automated all these.
Thanks in advance.
Smith.
February 16, 2015 at 2:00 am
No response at all... 🙁 🙁
February 16, 2015 at 4:24 am
The DMV is not the performance counter. It's just a view on top of them. It might not resolve in the same way as going directly to the performance counters themselves.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
February 17, 2015 at 1:52 am
OK... Thanks.
Is there any workaround for this ?
February 17, 2015 at 4:46 am
Assume the right answer is always in the Perfmon Counters themselves and anything else is an interpretation on top of it and make allowances accordingly. Not a great answer, but the only one i have.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply