logo
Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
Tijs  
#1 Posted : Tuesday, October 19, 2010 1:59:45 PM(UTC)
Tijs

Rank: Sienn Developer

Reputation:

Groups: Administration
Joined: 10/8/2008(UTC)
Posts: 25
Man
Location: Netherlands

Please note, perform steps below only if you are a DBA and know what the impact of this can be!


1. SQL Profiler
Start SQL profiler, create a new trace and select the template "Tuning". Choose to save the trace as a file. Click the second tab and uncheck all but TSQL section and start the profiler.
Let the profiler run until a representative snapshot of the activity has been made (eg walk through the site yourself, preferably in places where the hiccups are.
Stop the profiler

2. Database Engine Tuning Advisor
Start the Database Engine Tuning Advisor and start a new session.
Load the newly created file as workload, select the catalog you want and then start optimizing analysis.
Once the Advisor has finished, he gives what he can to optimize performance and what the profit percentages are.
On the Actions menu, click Apply Recommendations and go. He puts it on the basis of the workload exactly the indexing of that particular situation are best!

In specific cases we got SQL performance improvements over 90%!

Wanna join the discussion?! Login to your Sienn Forum forum account. New Registrations are disabled.

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.