did u ever found out what it is?

I assume its because of the process sp_server_diagnostics, it seems to be causing consistently 50% CPU

SQL is 2012 SP1 CU5

have same setup...

nice one....thats right code

Updated code with AWE as well...

I am trying to reconcile memory usage on my servers as some of em have memory issues...

Its been 2 days and going through numerous...

any thoughts what could be happening? or what else to look for?

I also checked awe is disabled on all systems, there is enough vas memory block available on all systems...

To add some more data on this post, I summarized same data from several other servers running same application as attached (based on client size resources differ), all are VM...

found fix if location is set to PS SQLSERVER:\> UC is not accesible thus changed it to c:\:

Get-ChildItem "\\server1\c$\" | Select-Object -first 1

Import-Module 'sqlps' -DisableNameChecking

set-location "c:\" -PassThru

Get-ChildItem "\\server1\c$" |...

not working

i want party:)

this happens google search always works better, i always type "sqlservercentral <search criteria>"

google is way faster

I was able to reproduce the issue

Seems when one copy the code and run it, it has special character get added due to HTML, invisible though but in windows 2003...

Also update declare variable part like below:

declare @ServerTime datetime , @ConvertMiliSeconds bigint

, @FilterMoreThanMiliSeconds bigint

, @FilterHours bigint, @execution_count bigint

, @debugFlg bit

select @ServerTime = getdate(),@ConvertMiliSeconds = 1000

,@FilterMoreThanMiliSeconds...

What is the version of SQL server you are using?

Try commenting the "queryexecuted" column code and run same

Check this article for how to use this script[/url]:

Prakash

http://www.sqlfeatures.com

rfr.ferrari (2/24/2012)

I've not configured without heartbeat, I had no time!!!,...

Very interesting, all votes for using heartbeat....

I have configured without hearbeat as new quoram model support with no issue...

Its a small issue in vmware mscs world as you need extra...

Allow me to be devils advocate in favor of SQL VM's:)

I dont see the argument of SQL VM are bad performer stands valid anymore, its just that there are few...

Thanks for jotting down steps, its easy to redone steps that way...made changes see if this works for you...

Pre steps:

1. Have both nodes configured and failover cluster feature installed

2. Take...