SQL Server cluster performance baseline
- by Dwight T
Currently I'm tasked with getting a good performance baseline on a SQL 2005 cluster. The main db on the server is for Sharepoint, but I would like to add other dbs on the cluster.
I do have access to Quest's Performance Analysis tool to help. What are key factors to look at to see if the cluster can handle additional dbs? Do you look at different performance indicators for a cluster vs a stand alone sql server?
One db will be a low usage transactional db and a read only db that is used for sales data.
Thanks
Dwight