Hey Richard,
No, there is no way to change the isolation level at the database level
in
SQL 2000.
If you experience locking contentions, please try to analyze which
transactions, connections, and stored procedures are causing the most
problem. Then perhaps you can change the isolation level of just a few
stored procedure. You may also want to look at if lock escalation is a
problem. Changing every stored procedure to read uncommitted isolation
level is usually not the right answer. It may cause data consistency
problems if the application is not designed to work with read
uncommitted
isolation level.
Just for your information, if you are MSDN subscriber, and you are
interested in looking into features of SQL 2005 beta 2, there is a
feature
called "snapshot isolation", which allows you to set a flag on the
database
and make read committed isolation level take no locks while still
returning
consistent and committed results.
It's Fridayyyyyyyyy! Partyyyyyyyyyyy! Hehe.
Have a great Day and Weekend!
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Richard Wadsworth
[mailto:mssqldba-ezmlmshield-x41729652.[Email address protected]
Sent: Friday, June 29, 2007 5:16 AM
To: LazyDBA Discussion
Subject: Transaction Isolation Level
Hi,
Is there a way of setting the transaction isolation level for a DB
(possibly even at server level). I'd like our reporting DB to be set to
read uncommitted, but I can't see how to do this without changing this
for all procs.
Any ideas?
Thanks
Rick
Richard Wadsworth
Database Administrator
CARCRAFT
E: richard.[Email address protected]
T: 07811 341277
Nixon Street, Rochdale OL11 3JW
www.carcraft.co.uk
This email and any files transmitted with it are strictly confidential.
It is for the intended recipient only. If you have received the email in
error please notify the author by replying to this email. If you are not
the intended recipient you must not disclose, distribute, copy, print or
rely on this email in anyway. Any views which are expressed in this
e-mail are solely the personal opinion of the author and do not
necessarily represent the views of CC Automotive Group Limited.
Registered in England and Wales No: 819414. Registered office: Nixon
Street, Rochdale, Lancashire OL11 3JW. This footnote also confirms this
email message has been swept for the presence of known computer viruses
before transmission.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page