Posted by Erland Sommarskog on 06/18/07 21:30

(szymon.strus@gmail.com) writes:
> Both databases are identical, the servers runs on the same machine
> (Pentium 2,8 Ghz, 2 GB RAM) with only one client connected. On forums
> I've read that Microsoft doesn't recommend using server side cursors
> on sql 2005 but is there any way to increase performance to some
> acceptable level?

Have you tried running the queries that spawns the cursors from a query
window to compare the results? It could be an issue with the query plan.
If the database was upgraded from SQL 2000, be sure that you run
sp_updatestats, as statistics are invalidated when you upgrade the database.

What style of cursors do you use? Dynamic, keyset, static or forward_only?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Search: CONTAINSTABLE
• Prev in forum: Re: Hiding the Database list from a certain user\group
• Thread view: Re: mdac 2.8 and sql 2005 cursor performace issue

[Reply to this message]