December 14, 2005 at 5:59 pm
My server is x366 (02 CPU 3.16GB, 4GB memory, 6x73GB HDD/RAID5-C,D,E,F,G-CDROM)
- MS Windows 2003 Std + SQL Server 2000 Std (SP4) for SQL Server Database Server purpose ONLY (client/server app).
1. My server's partition:
C:\ (25GB for OS + SQL program install )
D:\ (50GB for Database data files .MDF)
E:\ (50GB for Database log files .LDF)
F:\ (150GB for backup data)
it is optimize?
2. I see SQL 2000 Std (SP4) used maximum 2GB memory /4GB? How to config to more than 2GB for SQL Server, example for 3GB?
3. My application has a table that is frequent access (select/insert/update). This table now about 100000row (total DPAGES 17556, size 125 MB) and grow 5000 rows/1 month. I can share memory with marks this table able to be pinned into memory to enhance performance (DBCC PINTABLE)?
4. Another solution to use 4G memory to take effect?
Sorry, my English is bad.
Pls help me! Thanks in advcance!
Hung PT
December 16, 2005 at 12:22 am
Hi,
For large tables like that of yours, it is better to place table in one filegroup, place indexes in other filegroup on DIFFERENT PHYSICAL DISK ARRAYS. SQL server can access the table and indexes with seperate threads.
Thanks & Regards,
Ramanathan M.
December 16, 2005 at 1:37 am
SQL Server 2000 Standard Edition can use 2GB of memory, so to use 3GB you will have to update to the Enterprise version.
Set the /3GB setting in the boot.ini file to reserve 1GB for the Operating System.
Use a seperate system for backups and realocate the 150 GB to the Log and Data partitions. My rule is that each should have 3x the expected max size of the objects (LDF and MDF).
USB and Firewire removable HD are cheap $300 for a 250GB drive, backup speed and redundancy is not generally a requirement.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply