Tagged Questions
8
votes
1answer
979 views
SQL Server TempDB behaviour in large memory environment
Reading over In-memory SQL Server log file reminded me of a question I had a short while ago.
We have a SQL Server that has 512GB of RAM, the main database is (only) 450GB. We see quite a lot of ...
1
vote
2answers
261 views
Does it ever make sense to use RAM Disk to force RAM allocation for tempdb with SQL Server 2008
If I give all RAM to SQL Server, it will use it's own pattern to determine what RAM to allocate for what.
If I allocate portion of RAM as RAM Disk and put tempdb into that disk it will force RAM
...
2
votes
2answers
246 views
How to quantify TEMPDB usage in relation to other databases hosted on same hardware?
Working on a project to decide if configuration 1 or 2 is the best way to organise disks for my SAN:
Config1 (sql 2008):
8 disks @ raid 10 data
2 disks @ raid 1 logs
2 disks @ raid 1 tempdb
2 disks ...
