Thanks for the update...and yes I was able to pull the graph.
But is there a way to view any external or internal factor is causing deadlocks.
Is it to do with paging what the developers code to fetch the records.
And what is the purpose -EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters
Thanks in advance...