Good Day
I am a newbe - NO NOT ANOTHER ONE AAAAHHHH !!!
Here are the quandaries I have.
First some back ground on the systems I run.
The first is a Dell 2450, 750mhz, 1gig Ram, Raid 5
The setup is a C:\ which is 4gigs on Raid 5 container 0 which has the OS only on it, setup standard NT2000 server install.
The other is D:\ which is 12gig on Raid 5 container 1 which has the main app on it.
The second is a Dell 2450, 2x600mhz, 1gig Ram, Raid 5
The is setup a C:\ which is 4gigs on container 0 Raid 5 which has the OS only on it, setup standard NT2000 server install.
The other is Raid 5 D:\ which is 36gig on container 1 which holds the database.
My mission in life right now. If I accept it is to make both these machines as lean and mean as possible. No unnecessary OS services running or bottlenecks for data transmitions to and from the database.
The second machine has the Sybase 11.9.X database on it. This database is accessed from the first dell, which has the main app on it.
So after being so long winded. Here are my questions.
I am to understand that the pagefile on the c:\ must be at least 1.5x the size of the RAM for optimal speed in sending and receiving data from the database for large queries. Even though the database is on is own D:\ drive – Raid 5 container, will it still access the pagefile on C:\ ?
The majority of the queries retrieving and writing to the database last about 1 second. There are 50 or 60 queries at any given second. The machines as they stand are not getting over loaded. But the future will see 1300 to 1500 queries a second and I don’t want any bottleneck problems.
I need a clean simple plan to make sure that all is doing what it’s suppose to do and do it fast.
Oh ya I can rip these machines apart and redo the Raid 5 and OS anywhy I want in the next month or so.
I am a newbe - NO NOT ANOTHER ONE AAAAHHHH !!!
Here are the quandaries I have.
First some back ground on the systems I run.
The first is a Dell 2450, 750mhz, 1gig Ram, Raid 5
The setup is a C:\ which is 4gigs on Raid 5 container 0 which has the OS only on it, setup standard NT2000 server install.
The other is D:\ which is 12gig on Raid 5 container 1 which has the main app on it.
The second is a Dell 2450, 2x600mhz, 1gig Ram, Raid 5
The is setup a C:\ which is 4gigs on container 0 Raid 5 which has the OS only on it, setup standard NT2000 server install.
The other is Raid 5 D:\ which is 36gig on container 1 which holds the database.
My mission in life right now. If I accept it is to make both these machines as lean and mean as possible. No unnecessary OS services running or bottlenecks for data transmitions to and from the database.
The second machine has the Sybase 11.9.X database on it. This database is accessed from the first dell, which has the main app on it.
So after being so long winded. Here are my questions.
I am to understand that the pagefile on the c:\ must be at least 1.5x the size of the RAM for optimal speed in sending and receiving data from the database for large queries. Even though the database is on is own D:\ drive – Raid 5 container, will it still access the pagefile on C:\ ?
The majority of the queries retrieving and writing to the database last about 1 second. There are 50 or 60 queries at any given second. The machines as they stand are not getting over loaded. But the future will see 1300 to 1500 queries a second and I don’t want any bottleneck problems.
I need a clean simple plan to make sure that all is doing what it’s suppose to do and do it fast.
Oh ya I can rip these machines apart and redo the Raid 5 and OS anywhy I want in the next month or so.