December 8, 2008 at 12:08 pm
Hi,
We have a 3 node ACtive\Active\Passive cluster environment for sql server 2005 EE x64 with SP2 on windows 2003 R2 x64 with SP2.
On node 1, We have Drives C, D,E,F,G.
C-OS
D-PRIMARY
E-SECONDARY
F-LOG
G-TEMPDB.
so far, we did not used the 'E' drive,nothing is stored in E drive. But it showing up as it occupied 5GB of data. when open the E drive nothing is there,it totally empty.
No data is there on E drive,but why it showing as it is filledup with 5GB data.
Could you plz explain me what are the things I need to look for?
Do we need to apply any cumulative updates after applying SP2?
Thanks
Madhu
December 8, 2008 at 12:10 pm
Could it it be Page swapping that it is using that much space?
-Roy
December 8, 2008 at 12:17 pm
I would certainly check on the pagefile being located on that drive.
Right click on My computer then drill down to
System Properites
Advanced (tab)
Performance - Settings
Advanced (tab)
Change
and look at the pagefile and see if the location is the drive you are missing space on.
It's good practice to move the pagefile off the system drive.
The other thing you can do is turn off hidden system files, and look to see if pagefile.sys exists on that drive.
December 8, 2008 at 1:02 pm
Thank you,
I did the following:
Right click on My computer then drill down to
System Properites
Advanced (tab)
Performance - Settings
Advanced (tab)
Change
here,
Drive: Paging file size(MB):
C: 1024-4092
For the other drives Paging file size is empty.Is this fine? or do I need to change anything here and how to turn off hidden system files
December 8, 2008 at 1:07 pm
You should ask your Server Admins to move the PageFile from C Drive to to either D drive or E drive. C is the OS drive.
Also it does not hurt to see hidden files. You do not HAVE to change the Directory viewing properties in the explorer.
-Roy
December 8, 2008 at 1:22 pm
Here its showing total paging file size for all drives as 2046MB.If we move these 2046MB size paging files from C drive to the 'E',we can see 2046MB on E drive but still there is 2 more GB data is unknown.(Because total occupied size on E drive is above 4GB)
December 8, 2008 at 1:55 pm
To show hidden and system files:
Open Windows Explorer
Tools
Folder Options
View (tab)
Change Radio Button on "Hidden files and folders" to Show
Uncheck "Hide extensions for known file types" (a nice to have)
Uncheck "Hide protected operating system files" and hit ok at that warning
Once you've had a look around, unless you are comfortable in windows go back and check the "Hide protected operating system files" box again, just so as you don't hit something accidentally that you don't want to.
December 8, 2008 at 1:57 pm
1. An empty formatted drive should show less than maximum capacity since formatting itself occupies some space. The space occupied depends on the size of your HDD.
2. When moving your paging file from c: drive to e: make sure that it's max size is set according to MS recommendations: http://support.microsoft.com/kb/889654
December 8, 2008 at 2:04 pm
Is the E drive a clustered resource? Sorry, forgot to ask.
December 8, 2008 at 2:51 pm
yes, the E drive is a clustered resourece.
December 9, 2008 at 5:03 am
That makes me wonder if the pagefile was accidentally put on there and then ripped from the system on a failover.
Were you able to check the hidden and system files to see if there was anything on there?
December 9, 2008 at 4:30 pm
Do you want me to move the E drive to passive node and check if I can see something?
is this any thing related to NOT installing any cumulative updates after installing SP2?
plz clarify me.
December 9, 2008 at 4:56 pm
There's really no need to failover. Were you able to look for hidden or system files on the drive?
Perhaps one of your NT admins could take a look and see what the issue is.
Is there any chance you could provide a layout of the disk and the information for that disk from the disk management interface?
Also, what drive are you using to host the quorum and msdtc resources?
December 11, 2008 at 1:10 pm
Volume Layout type filesystem status capacity freespace %frees faulttolerance overhead
E partition basic NTFS healthy 100 93.98 95% no 0%
What woulb be the page file size for sql server application, because Iam gettimg low virtual memory from the spot light monitoring tool?
December 11, 2008 at 1:17 pm
Guessing that the disk size is in GB, would that be correct?
And you don't see any files - hidden, system or otherwise?
The low virtual memory is another issue entirely, what is the size of your pagefile? How much memory is in the server? What kinds of queries are you attempting to run? What is being paged?
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply