|
Home > Archive > MS SQL Server > January 2006 > Slowness of SQL2k5 in comparison with SQL2k
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Slowness of SQL2k5 in comparison with SQL2k
|
|
|
| I have database. The database is pure OLTP database. Performnace is very
important for the database. 90% of all db calls is call of 4 stored
procedures. I created test script which do such calls. I do performance tests
both in SQL2k and in SQL2k5. Databases have exactly same data. I did update
statistics and rebuild of indices in SQL2k5 after resore from SQL2k backup.
I encountered strange problem - in SQL2k5 test script works ~30% more slowly.
Exactly same execution plans, no difference. Test computer - 2 x Xeon 3.6
GHz, EMC CX500 direct attached. After looking at counters, I found only one
possible reason of slowness - SQL2k5 for the SPs write ~30% more data to
transaction log. Why it is so, what can be done to have at least same
performance as is in SQL2k?
| |
| Michael Hotek 2006-01-31, 3:23 am |
| Can you help us a bit by posting code and database structure?
--
Mike
http://www. solidqualitylearning
.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"andsm" <andsm@discussions.microsoft.com> wrote in message
news:F4DA20A9-DF3E-4780-8D68- 2032CA789967@microso
ft.com...
>I have database. The database is pure OLTP database. Performnace is very
> important for the database. 90% of all db calls is call of 4 stored
> procedures. I created test script which do such calls. I do performance
> tests
> both in SQL2k and in SQL2k5. Databases have exactly same data. I did
> update
> statistics and rebuild of indices in SQL2k5 after resore from SQL2k
> backup.
> I encountered strange problem - in SQL2k5 test script works ~30% more
> slowly.
> Exactly same execution plans, no difference. Test computer - 2 x Xeon 3.6
> GHz, EMC CX500 direct attached. After looking at counters, I found only
> one
> possible reason of slowness - SQL2k5 for the SPs write ~30% more data to
> transaction log. Why it is so, what can be done to have at least same
> performance as is in SQL2k?
|
|
|
|
|