MS SQL Server - query's tune

by Roland Schumacher alias GENiALi 5. April 2007 -- 234 words -- 1 mal gelesen

Programming is only as a hobby of mine. Nevertheless
do I relatively much in the company. There are in between massive
Things that are mine. Most programs access this
on a SQL DB to.

In recent weeks the timeout's accumulated more and more in
Query. There are various tools who wanted more fairly. It was necessary to
more often two to three times update until a result there was.

Today I took care of me times therefore.

I have to angeschmissen SQL Profiler to SQL Server.
There is a "SQLProfiler tuning" template. I read only the me
Queries show lasting longer than 1000ms. To my surprise
there of which were very many. What surprised me also they all came
from my applications.:-(

OK. Then I took the SQL query of a query over 30'000ms took.
I read that in the SQL Query Analyzer run and looked me the
Execution plan. He told me, however, not much.

Under the menu item query I found the Index Tuning Wizard.
The I read then run. To my surprise he said I could
make DB 99% faster. I did and have safe
demand in a forum. That meant only.

So I let the create proposed index and then the query
run again. Before 30'000ms afterwards...

Only 16ms. Yup, only 16ms. Flups and data but no timeout
were there.

Now I take me all > 1000ms before and do the same. The
Results are simply stunning.