|
Replies:
5
-
Pages:
1
-
Last Post:
Nov 10, 2009 11:07 AM
by: ariel.weil@ques...
|
|
|
Posts:
40
Registered:
12/9/08
|
|
|
|
All Drives are NOT visible from Spot light
Posted:
Nov 6, 2009 10:43 AM
|
|
|
Hi,
We have Spot light for SQL Server and Monitoring Clustered Servers. We have 1 instances on Node1 and 2 instance on Node3.
For the 3 instances, we have the following drives:
Node1: Instance 1:
C: OS
D:Data files
E: Secondary data files
F: Log files
T: TempDB
Z: Backups
Node2: Instance 2:
C: OS
G: Data
H: Secondary data files
I: Log files
J:TempDB
X: Backups
Node2:Instancen 3
K: Data
L:Secondary
M: Log
N:TempDB
X: Backups
and the cluster drives Q->Quorum and Y Msdtc.
from spot light I have made connections as below:
1. File->Connect->select Spot light on Windows Enterprise->New connection and given the Virtual server name, SQLVS1
2.File->Connect->select Spot light on SQL Server Enterprise->New connection and given the Virtual server name\instance name, SQLVS1\INS1
3. File->Connect->select Spot light on Windows Enterprise->New connection and given the Virtual server name, SQLVS2
4.File->Connect->select Spot light on SQL Server Enterprise->New connection and given the Virtual server name\instance name, SQLVS2\INS2
5. File->Connect->select Spot light on Windows Enterprise->New connection and given the Virtual server name, SQLVS3
6.File->Connect->select Spot light on SQL Server Enterprise->New connection and given the Virtual server name\instance name, SQLVS3\INS3
Now the Problem is:
For NODE1
From Spot light, for Instance1, I'm able to see only C, Y & Z drives and I'm NOT able to see the drives D, E, F, T (When I Connected to Spot light on Windows Enterprise, i.e SQLVS1 ).
For NODE2:
For instance 2, I'm able to see the drives C, G & C(again) drives and I'm NOT able to see the drives H, I, J, X (When I Connected to Spot light on Windows Enterprise, i.e SQLVS2 ).
For instance 2, I'm able to see the drives C, G & C(again) drives and I'm NOT able to see the drives K,L,M, N,X (When I Connected to Spot light on Windows Enterprise, i.e SQLVS3 ).
Why Its showing same drives twice for Instance 2 & 3? and shwoing C drive twice!!
What Should I do to see all the drives related to one Instance, I mean if I connected to Instance1 (Spot light on Windows Enterprise, i.e SQLVS1 ), I should see C, D, E, F, T & Z also Q & Y?
I would like to attach the screen shots here but I did not find that option.
thanks
Message was edited by: charan
Message was edited by: charan
Message was edited by: charan
|
|
|
Posts:
40
Registered:
12/9/08
|
|
|
|
Re: All Drives are NOT visible from Spot light
Posted:
Nov 9, 2009 3:47 PM
in response to: charan
|
|
|
Please advice me on the above..
many thanks
Message was edited by: charan
|
|
|
Posts:
156
Registered:
5/19/08
|
|
|
|
Re: All Drives are NOT visible from Spot light
Posted:
Nov 9, 2009 4:32 PM
in response to: charan
|
|
|
Gary, can you see all the drives from perfmon when you look at the SQL Server IO counters?
|
|
|
Posts:
77
Registered:
3/13/07
|
|
|
|
Re: All Drives are NOT visible from Spot light
Posted:
Nov 10, 2009 6:46 AM
in response to: ariel.weil@ques...
|
|
|
Are you not seeing the drives on the Spotlight on Windows Homepage? Or are you not seeing the drives on the physical and/or logical disks drilldowns? The homepage is only designed to show you a subset of your disks (it will rank them by some metric), whereas the drilldown is designed to show you statistics about all of your disks.
Cheers,
Jason
|
|
|
Posts:
40
Registered:
12/9/08
|
|
|
|
Re: All Drives are NOT visible from Spot light
Posted:
Nov 10, 2009 9:56 AM
in response to: jhall
|
|
|
thanks,
Disks->rightclick->global->allow up to eight disks on home page(I have selected this option and then I'm able to see only 6 drives from home page instead of 8. What should I do to Display all available drives )
->show files button on home page(This option was selected by default
Next to Global:
Instance name and below that there is a option called Number of disks to show on home page & in the drop down '6' selected and its grayed out? How can we change this option?
thanks
Message was edited by: charan
|
|
|
Posts:
156
Registered:
5/19/08
|
|
|
|
Re: All Drives are NOT visible from Spot light
Posted:
Nov 10, 2009 11:07 AM
in response to: charan
|
|
|
Hi Gary,
SoSSE can only show disks that are owned by the physical machine. Guessing here, the drives are probably mapped drives. We really would need a support bundle to explain this fully (via a Support case). It would be helpful to have the 2 windows connections open whilst generating a support bundle.
Using perfmon, and viewing the instances for the logical disk performance object, do you see any differences in that information and the information Spotlight displays?
Regards,
Ari Weil
Quest Software
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
