Prev: Getting text message from DBCC commands
Next: UPDATE using SUM
From: Upender Yadav on 10 Aug 2010 08:05
Dear all,
I am using sql server 2008 r2 as a database and have enabled
few properties of it as

alter database databasename set ALLOW_SNAPSHOT_ISOLATION on
alter database databasename set READ_COMMITTED_SNAPSHOT on

because I wanted it to use it in buffering mode. Now I am facing problem as
my sql server database hangs up quite often.
Please give me suggestion to tackle this problem as I wanted to run it in
buffer mode.

Thanks



From: Erland Sommarskog on 10 Aug 2010 16:04
Upender Yadav (upender.yadav(a)yahoo.co.in) writes:
> I am using sql server 2008 r2 as a database and have
> enabled few properties of it as
>
> alter database databasename set ALLOW_SNAPSHOT_ISOLATION on
> alter database databasename set READ_COMMITTED_SNAPSHOT on
>
> because I wanted it to use it in buffering mode. Now I am facing problem
> as my sql server database hangs up quite often.
> Please give me suggestion to tackle this problem as I wanted to run it in
> buffer mode.

What does "hang up" mean? Does it not accept connections at all? Are only
certain queries slow?

The first start is to check the SQL Server error log to see if there
are any alarming messages.

If there are not, you need to be able describe the problem more
accurately. Is the problem only with one database? The entire server?
only some queries?

There is nothing that says that it has anything to do with snapshot,
but it could be completely unrelated.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Getting text message from DBCC commands
Next: UPDATE using SUM