Bill Galashan, DBA of bet365 sent over the following query that lists the execution plan of the 10 most frequently executed queries.
He writes:
We got into this due to different query plans coming from a VB or a web app than what was seen when running the same query from Management Studio. Eventually tracked this down to a difference in the set options predominatley whether Arithabort was on or off.
Read more to see his query. Read the rest of this entry »
Tags: dynamic management views, execution plan, SQL Server 2005, SQL Server 2008, SQL Server Administration, SQL Server Engine
I have been working on a performance problem recently, so you might see several blog entries with information that help me. Hopefully they will help you.
Update: Here is a query to get the execution plan of the most frequently used queries.
Getting the SQL Server execution plan from a production can be difficult, since you are not running the code within Enterprise Manager. You can still get the execution plan of any running statement and display the graphical representation in Enterprise Manager. Read the rest of this entry »
Tags: dynamic management views, execution plan, performance, SQL Server 2005, SQL Server 2008, SQL Server Administration, SQL Server Engine
SQL Server 2008 includes a new HierarchyID datatype!
Tags: SQL Server 2008
Arclite theme by digitalnature | powered by WordPress