I'm planing on doing a database analysis tool to deploy to our customers and determine their problems.
We have customers complaining on database performance and other things related with the database.
There are some "cool" tools out there (Red Gate, Idera, ...) but they are some what expensive and I can't use them in our customers.
So our company decided to build a tool the be deployed with our SW.
I plan on taking some indicators from the database so we can analyze them on premises.
Is Red Gate "SQL Server DMV Started Pack" a good "place" to start, to use the DMV queries on the database analysis tool?
PS: Like I said on previous posts our customers have poor servers (regular Dual Cores with 4G Ram, Sata disks, no RAID...). That's a BIG problem but our queries aren't quite well written.. So I'm focusing on the database performance problem and not server design/implementation... obviously there will a recommendations document for the database server but we are talking about companies with 4 to 5 people and sometimes the database server is the "boss" laptop..
If you need to work better, try working less...