Tagged Questions
3
votes
1answer
72 views
Buffer usage for index with no reads
Using SQL Server 2008 R2, the main transactional table in a vendor database is massive compared to all others and has about 14 indexes. Some of these indexes don't get used in our environment, but we ...
-1
votes
2answers
163 views
SQL Server Express - Memory limitation vs. web application [closed]
I have web application that will be similar to forums. I plan to have thousands of users on this application, and I wonder if I can use SQL Server Express.
Here is the list of it's limitations:
...
2
votes
1answer
429 views
Determining SQL Server memory requirements
I just a bit of an issue there where a SQL Server database was eating up quite a lot of RAM for its size.
A bit of background:
The database is for a small content managed website. The CMS is custom ...
1
vote
1answer
1k views
Quick look at how much RAM is allocated to SQL Server?
With SQL Server 2005, you could look at the Task Manager and, at least, get a cursory look at how much memory is allocated to SQL Server.
With SQL Server 2008, the Working Set or Commit Size never ...
5
votes
2answers
224 views
Can I prove my database does not have memory issues?
(This is a continuation of do indexes consume memory)
A fellow database developer believes we are having memory issues. He has seen increased run times in some standard queries - going from under 10 ...
7
votes
3answers
4k views
SQL Server Max Memory not limiting use of RAM
I would like your input on this. I have a sql server 2008r2 Ent. Ed. 64bit with 16 cores and 64GB RAM. There is one instance of SQL server patched fully as of 20111014.
The max ram is set to 60000MB. ...
11
votes
3answers
2k views
SQL Server 2008 R2 “Ghost Memory”?
We have a dedicated SQL Server 2008 R2 machine that is experiencing some strange memory issues.. The machine itself has plenty of resources including two quad-core processors, 16gb of RAM and 64bit ...
14
votes
3answers
18k views
Recommended page file size for SQL 2008R2 on Windows 2008R2
This Microsoft article - How to determine the appropriate page file size for 64-bit versions of Windows Server 2008 and or Windows 2008 R2 provides guidance for calculating the page file size for 64 ...
