Tuesday, March 20, 2012

Performance problem with SQL Server Express

My current database is running in MSDE.I setup a new server and installed SQL Server 2005 Express.I then copied the database to the new server and attached it.After testing the new server, I noticed that one of my stored procedures that uses a forward_only keyset cursor is running about ten times slower.I’ve compared all the setting between the two servers and everything looks good.I also installed a trial copy of SQL Server 2005 on a spare PC and ran the same test.Again, the stored procedure is running about ten times slower.I’m not experiencing any other performance problems.

Any help would be appreciated.

Thanks

You might want to ask this question on the SQL Server Database Engine forum. I don't expect the Express edition to be any different from the standard one for cursor functionality.

Thanks
Laurentiu

No comments:

Post a Comment