May 13, 2009 at 10:02 am
Hi,
We have a/a/p clustered sql server 2005.On node 1, we have 1 instance, on node 3, we have 4 instances and node 2 is paasive.
When we installed the sql server:
1. Selected the default path for database engine, reporting services and integrations services(C:\program files\Microsoft SQL Server\) - because it did not allow us to select other than C:drive(I do not know why )
2. Selected D: drive for datafiles(when the wizard asks for Datafiles location, We Selected D:\Microsoft SQL Server\)
3.Later, we moved log files to E drive and TempDB to T drive.
4.Keeping Backups on Z drive.
My Question is Step 1 is correct or wrong? Because We are getting the following alaram from Quest Spot light
Physical disk #0 C: containing paging file(s) 'C:\pagefile.sys' is experiencing a high rate of I/O (98.79% busy) unrelated to paging.
Physical disk #20 Z: containing paging file(s) 'C:\pagefile.sys' is experiencing a high rate of I/O (100% busy) unrelated to paging.
Is selecting the C: drive for the features to install causing this problem? anything wrong in the installation?
please advice me
thanks
May 13, 2009 at 1:16 pm
SQL Binary files will reside on each node of the cluster, all other files should be on shared drives (SAN) including the Master.mdfs. Not sure if your D Drive is on a SAN or Local machine.
Next, how big is the C drive, how much memory do you have on these machines? This sounds like a lot of paging going on that is unrelated to the OS, IE SQL maybe?
Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g
May 14, 2009 at 3:39 pm
thank you,
All the drives are on SAN including C drive too.
total_Space on C:Drive = 50 GB.
free_Space on C: Drive = 40GB (So only 10GB has used so far)
Memory = 16GB
Page file Size = 2046 MB
What is IE SQL? where can I check? how can we make sure what causing this issue and how to resolve it?
thanks for the information
Madhu
May 26, 2009 at 5:51 pm
Selected the default path for database engine, reporting services and integrations services(C:\program files\Microsoft SQL Server\) - because it did not allow us to select other than C:drive(I do not know why )
2. Selected D: drive for datafiles(when the wizard asks for Datafiles location, We Selected D:\Microsoft SQL Server\)
The installation to C: drive is correct. Because if you select any drive other than C: drive, you will get below error:
see the attachment for the error message.
Let me know if Iam going in a wrong way....
June 4, 2009 at 10:57 am
Hi,
We are getting the below alaram frequently in Spot light
Alarm raisedPhysical disk #0 C: containing paging file(s) 'C:\pagefile.sys' is experiencing a high rate of I/O (99.07% busy) unrelated to paging.
as you said, I verified the installation path for sql server and it is C drive. Because it is a clustered sql server (A/P), we must need to select the C drive for the installation(I tried to select other than C drive but its giving me the error. see the attachment) and we can choose the the other drive for data files. I did the same way.
is this the way to install sql server in cluster environment.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply