Viewing 15 posts - 4,651 through 4,665 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2012 at 4:54 am
you created the SPNs for the virtual network name against the sql server service account?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"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
Viewing 15 posts - 4,651 through 4,665 (of 9,244 total)