I'm currently building a new Windows 2008 R2/SQL 2K8 Failover Cluster and waiting for SAN disks provisioning from the storage team. I am also planning to run a disk I/O measurement tool and save the result as a baseline metrics for future references.
One tool comes in mind is SolarWind SAN Monitor for EMC Clariion.
Are there any other good free tools that I can use? And also, what are the key elements that are essential to disk performance and I should incorporate into my test? Almost new to this area.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention.
Multiple USB devices need t…