Viewing 15 posts - 4,651 through 4,665 (of 9,253 total)
govindarajan69 (11/8/2012)
Even i have the same understanding that the sql server should not go down due to network issues whether it is private or public.
No, stop, this is incorrect.
Kindly...
November 8, 2012 at 11:45 pm
CuriousDBA (11/8/2012)
Yes. we have created SPN for all the servers including Virtual server Name (Cluster)
what do you mean all servers? The only SQL Server SPNs should be the ones created...
November 8, 2012 at 6:04 am
rupengzhao (11/7/2012)
November 8, 2012 at 5:15 am
November 8, 2012 at 5:12 am
Check your windows application and system logs, collate this info with the cluster events log. Can you post details of any errors reported, failure of the public network will initiate...
November 8, 2012 at 4:59 am
The best way is to use a simple WMI query as follows
wmic volume get capacity, "free space", name
If xp_cmdshell is disabled you can turn it on first then disable it...
November 8, 2012 at 4:54 am
you created the SPNs for the virtual network name against the sql server service account?
November 8, 2012 at 4:47 am
Unless arcserve is doing something different like snapshotting disk files.
Differential bitmaps are reset by a full backup in SQL server.
November 7, 2012 at 11:38 pm
Markus (11/7/2012)
I think I found a smoking gun....
I copied a 32 gig file from another server...
November 7, 2012 at 10:57 am
Markus (11/7/2012)
Don't know if there are any switches in between either.
A storage area network will have switches and lots of them 😉
Can you supply details of throughput please from...
November 7, 2012 at 8:15 am
Markus (11/7/2012)
http://blogs.technet.com/b/askcore/archive/2012/02/07/measuring-disk-latency-with-windows-performance-monitor-perfmon.aspx
Alongside this also capture throughput too using the following counterset
PhysicalDisk: Disk Bytes/Read
PhysicalDisk: Disk Bytes/Write
This will show throughput of data transferred to and from disk
November 7, 2012 at 7:48 am
devakishore.t1 (11/7/2012)
I am saying sql cluster name.
Ok, are you referring to the sql cluster group name in failover cluster manager?
November 7, 2012 at 7:15 am
Abu Dina (10/24/2012)
The good news is there are no T-log backups. All DBs are set to SIMPLE
And that's good news!!
So, none of your databases require a point in time...
November 7, 2012 at 6:03 am
montse 22199 (11/6/2012)
November 7, 2012 at 5:58 am
As i said, you have all the components in between the SAN and the SQL instance.
HBAs
HBA drivers
multipath drivers
Fibre channel switches
Etc, etc
Initially, check the Queue depth settings on the HBA(s)
November 7, 2012 at 5:50 am
Viewing 15 posts - 4,651 through 4,665 (of 9,253 total)