February 12, 2009 at 2:05 pm
[font="Verdana"]Good luck! The performance views between the two systems reflect very different architectures. You may be better thinking about what you specifically want to see from SQL Server, and starting from there, rather than assuming you just want to see the same stuff you saw from Oracle.[/font]
February 17, 2009 at 5:38 am
I assume that we will not be able to get the RAC metrics from SQL Server because in SQL Server failover clusters, two nodes do not communicate with each other except for sending heartbeats (is it right?).
However I may still be able to get or compute the parsing related metrics from SQL server somehow. Is there any wayto find the parsing time of a query in SQL server and the total parse count etc.
Regards
Nabeel Mukhtar
February 17, 2009 at 1:02 pm
nabeelmukhtar (2/17/2009)
I assume that we will not be able to get the RAC metrics from SQL Server because in SQL Server failover clusters, two nodes do not communicate with each other except for sending heartbeats (is it right?).However I may still be able to get or compute the parsing related metrics from SQL server somehow. Is there any wayto find the parsing time of a query in SQL server and the total parse count etc.
Regards
Nabeel Mukhtar
[font="Verdana"]Start with the SQL Server Performance Counters from SQL Server Books Online. Hopefully something comparible is in there.
A good way I have found with playing with this stuff is to fire up the Windows Performance Monitor tool, and just have a look at the counters that are offered and the kind of results you get back.
[/font]
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply