Viewing 15 posts - 4,651 through 4,665 (of 9,241 total)
Markus (11/7/2012)
I think I found a smoking gun....
I copied a 32 gig file from another server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2012 at 6:03 am
montse 22199 (11/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2012 at 5:50 am
What monitoring stats have you collected so far to supply to your SAN and infrastructure teams.
In between the SAN and the SQL Server you have all the other software\hardware components,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2012 at 4:28 am
chewychewy (11/7/2012)
For example only.
I have a daily full db backup via SQL maintenance plan to file system at 10pm.
I also have a daily direct backup of database via arcserve...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2012 at 4:25 am
The Windows cluster name and the sql server virtual network name have to be separate unique values
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2012 at 4:21 am
arkiboys (11/6/2012)
We are also taking regular end of day backups.
Question:
Is it necessary to do backups since mirroring is in place or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2012 at 1:29 am
arkiboys (11/6/2012)
Can the ReportServerTempDB database be mirrored onto the DR server?Thanks
Why are you considering mirroring on these databases?
Use scale out deployments and clustered instances of SQL Server to provide HA...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2012 at 1:27 am
What disk type are you using, what does Windows think the type is?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 11:50 pm
consecutive pageids, you may want to run a storage health check too.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 1:52 pm
jvkondapalli (11/5/2012)
We have APP1, APP2. When I create Windows Server Failover Cluster(WSFC) with 3 nodesnode 1 - Primary Replica - APP1 is connected with cluster name
The WSFC name is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 1:40 pm
Viewing 15 posts - 4,651 through 4,665 (of 9,241 total)