Hello,
I need some expert advise on below Database Files setting.
1. Server with 2 disk drives as below :
a. D drive : 1TB (For database files)
b. E drive : 1TB (For log files)
2. I have created 2 different databases for creating disk tables and in-memory tables.
3. For DiskDatabase, files are (default settings, I have not changed anything here)
a. DiskDatabase (Initial size : 2099MB, Auto growth by : 1 MB, Maximum size : Unlimited)
b. DiskDatabase_Log (Initial size : 4524MB, Auto growth by : 10 percent, Maximum size : limited to 2,097,152)
4. For InMemoryDatabase, files are (default settings, I have not changed anything here)
a. InMemoryDatabase (Initial size : 3MB, Auto growth by : 1 MB, Maximum size : Unlimited)
b. InMemoryDatabase_Log (Initial size : 1MB, Auto growth by : 10 percent, Maximum size : limited to 2,097,152)
c. InMemory_FileGroup (Initial size : 153MB, Auto growth by & Maximum size : Unlimited)
Questions are :
- Is it better to have disk database and in-memory database separate in terms of clearing transaction logs?
- Though both the drive sizes are 1TB, maximum file size shows : limited to 2 TB by default. Is that okay? Wont we get Transaction full error ?
Please suggest on this configuration of database where we have to run huge active transactions on millions of records.
Thank you,
Mittal.