December 1, 2022 at 10:50 pm
I need a script that generates a report saying that the machine's hardware is obsolete or heavy to run the database.
Do you have any script ready to do this?
December 1, 2022 at 11:16 pm
Do you have monitoring history to support such a report?
There is no simple correlation between hardware required and number of rows, gigabytes of data, or number of users, for example.
You need information on waits, disk queues, CPU usage, transactions per second, etc.
And it's not just the SQL Server hardware that matters. It's also the network. And the SAN if storage is not local. And the VM host hardware & VM configuration if virtualized.
December 2, 2022 at 9:18 am
Piling on a little. It's truly dependent on the load of the system, data size, number of transactions, transaction size, database design, statistics, indexes, code, code, code, system settings, version, patch, query statistics, wait statistics... THEN, we can say, CPU is too slow or too few, Memory is too little or too slow, disks, are too small, too few, too slow, etc.
There isn't a single metric that will tell you all of that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply