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 |
|
heliang
Starting Member
38 Posts |
 Posted - 2008-12-20 : 13:57:10
|
| I am still having this memory issue. I have assign 3GB to SQL server and only 4 or 5 people connect to it through application. It should not take 3GB. I have seen lots of locks with type EXT. What is this EXT type indicate? plus my tembdb file size is almost 8GB. Why it is so big? How should fix this?Thanks!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-21 : 13:06:31
|
quote:
Originally posted by heliang
I am still having this memory issue. I have assign 3GB to SQL server and only 4 or 5 people connect to it through application. It should not take 3GB. I have seen lots of locks with type EXT. What is this EXT type indicate? plus my tembdb file size is almost 8GB. Why it is so big? How should fix this?Thanks!!
But is Sql Server using 3 gb?Check in pert Mon for Total server Memory and Target Server Memory?I guess what you are seeing is locking issue not memory issue?Check whether you have enough index? Are you using too much temp table or table variable? Take advantage of indexes in temp table? |
 |
|
|
|
|
|
lock type EXT -- help!!