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 |
|
abhwhiz
Starting Member
37 Posts |
 Posted - 2007-09-13 : 05:50:29
|
| I wanted to know how much a memory, by default, a user/session will be using, in the server properties it is showing "minimum memory/query" as 1 MB. Is this the same value? |
|
|
mohit_sme
Starting Member
13 Posts |
Posted - 2007-09-13 : 15:42:43
|
| Take a look at the DMVs available in Microsoft SQL Server 2005. You will find something really useful for your problem.ThanksMohit Nayyarhttp://mohitnayyar.blogspot.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-13 : 22:45:23
|
| Run sp_who2, you'll get cpu time and memory usage of every connection. |
|
|
|
abhwhiz
Starting Member
37 Posts |
Posted - 2007-09-14 : 01:26:19
|
| I tried sp_who2, thanks. Is the CPU column in bytes?One of my DBA friends told me it is 1 MB/user, is this correct? He is talking abt the same setting i mentioned in my first question. It says 1MB/query. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-14 : 23:44:24
|
| Cpu time is not in bytes, it's system clock ticks. Memory usage is in 8k page. |
|
|
|
|
|
|
Memory used per User