Transaction locking in Sql Server

We have an old version of Cognos 7 running on Sql Server 2000 Enterprise.

It is issuing very badly constructed sql commands that are creating many locks which are escalating and blocking the server.

The targeted database is built once a day and then only used for selection.

As the Cognos queries can't be changed (short of upgrading to Cog 10), what can I do to improve this situation?

If I mark the database Read Only will this prevent the locks?

Answers


Locking does not happen in read-only databases, so this would (probably) help, assuming that locks are the only cause.

If you can issue a new query at the start of a session you could also change the transaction isolation level to read uncommitted, which would cause selects to ignore locks.


Need Your Help

cannot curl from tcl (eggdrop bot) after restart freebsd/freenas-jail

curl cron tcl eggdrop

I am running a freenas jail environment that run a few eggdrop scripts.

How can I make the browser see CSS and Javascript changes?

javascript css http caching

CSS and Javascript files don't change very often, so I want them to be cached by the web browser. But I also want the web browser to see changes made to these files without requiring the user to cl...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.