Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-11-02 : 03:26:17
|
| Hi we are using sql server 2005 EE Sp4. Our Database size is 150 GB.until last week it will worked fine. but now the database lot of blocks occurs during the transaction. why our databases suddenly behave like this? what are the possibilities are there?--Ragu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-02 : 05:29:04
|
| did you change isolation model of database? are you using too many transactions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-11-02 : 05:57:29
|
quote:
Originally posted by visakh16
did you change isolation model of database? are you using too many transactions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
we didn't change any properties of database.--Ragu |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-02 : 06:17:01
|
| is it having lot of batch jobs executing in background? have anybody added any new set of jobs recently?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-02 : 10:30:29
|
| check for fragmentation of your indexes. also, see if auto update statistics is set to true. Find queries which are blocking others. If it's the same query everytime, You'll need to optimize that query. |
|
|
|
|
|
|
Blocking