Hi, I am very much new to SQL Server DBA stuffs and I had given a task where I need to do a health check of a server. Currently it is having database which size is around 350GB. The hardware is like, 8GB RAM/8 Processor/SAN. Currently in peak hours approx 1 GB data process in every hour and now application team is going to upgrade their system. After application upgrade in peak hours approx 20-50 GB data will be going to process. So we need to do a health checkup in current and for future upgrade as well. Please suggest. Thanks in Advance.. Rahul
Welcome to the forums. Check: http://www.sqlservercentral.com/articles/Automating SQL Server Health Checks/68910/
In addition for what Luis has advised above , you can check also my blogs for DB healthy check and building your own monitors using DMV http://www.sqlserver-performance-tuning.com/apps/blog/show/13109729-main-db-checks-for-dba http://www.sqlserver-performance-tu...better-dba-dashboards-using-dmv-monitors-4-4- http://www.sqlserver-performance-tu...better-dba-dashboards-using-dmv-monitors-3-4- http://www.sqlserver-performance-tu...better-dba-dashboards-using-dmv-monitors-2-4- http://www.sqlserver-performance-tu...better-dba-dashboards-using-dmv-monitors-1-4- Please let me know if any further help is needed