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 |
|
onionpunk
Starting Member
3 Posts |
 Posted - 2008-07-16 : 02:44:29
|
| Hi guys,I'm new to the sql server and I've been trying to find out information about the sql 2005 express edition performance relating to the 1GB RAM.How big is that 1GB RAM? When can I expect that the server will start to be reduced in performance once the buffer pool has been exhausted?All I can see now in the SQL Management Studio Express is that the activity monitor shows that on average:- There are 30-35 in total of Memory Usage (I assume they are memory page). Each process uses 1-2 page- An active process usually has 2000-4000 Physical IOHow can I use those information to check whether the server workload is excessive?Thank you all in advance.Kind Regards,Alex |
|
|
Raibeart
Starting Member
8 Posts |
Posted - 2008-07-16 : 09:34:44
|
| The amount of ram will really determine the number of users that you can actively have hitting the Express databases. The less ram the less users. But, you can have a large number of users if they are not hitting the databases hard. I don't have Express installed, but if you want to see how the actual performance is doing over time, you should run a performance trace and evaluate it. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 23:41:23
|
| There are many perfmon counters for that, check them out. |
|
|
|
|
|
|
SQL Server 2005 Express 1GB RAM performance