March 12, 2012 at 9:15 am
Comments posted to this topic are about the item Get Top Queries Taxing SQL Server CPUs
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
March 12, 2012 at 11:54 pm
Hello Prakash,
Hope this reply finds you well...
Thank you very much for the post, by the way I am getting below error.
Please help me out to correct the same........
Is ther any setting from my SQL Server SMO to be done ?
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 37
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 49
Incorrect syntax near '?'.
March 13, 2012 at 3:24 am
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
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
March 13, 2012 at 3:29 am
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 = 1,@FilterHours = 2
,@execution_count = 2,@debugFlg bit = 0
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
March 13, 2012 at 5:42 pm
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 notepad and SQL 2012 SSMS editor I was able to see and replace it and than it works, not able to see that character in win7 notepad though.
let me know if you this doesn't work...
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply