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 |
|
pradeep_iete
Yak Posting Veteran
84 Posts |
 Posted - 2010-02-10 : 03:03:12
|
| Hi Friends, I have production database say, DB1 , installed on SQL Server 2005 Express (I have assumed constraints and bottleneck) My question is when DB1 invovles in heavy trasactions so that it uses up TempDB, Now my confusion is how SQL memory Buffer is utilized.Is it like Thinkline 1 : SIZE(DB1) + SIZE(TempDB1)<= 1 GBThinkline 2 : MAX ( SIZE(DB1) ) =1GB and SIZE(TempDB) fall outside 1 GB.I hope my question is clearThanks |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-02-10 : 23:09:58
|
| I'm not sure I really understand your question. I hope this article might help, though.http://www.mssqltips.com/tip.asp?tip=1432 |
 |
|
|
|
|
|
TempDb & Production Databse 's Buffer Memory