December 18, 2013 at 3:11 pm
Please let me know how to check the server health check ups. When we right click on the instance I am seeing some options Policies (Health States), Facets, Deploy Data-Tier Applications. What are the benefits of those. If any one knows please explain.
Thanks in Advance
December 18, 2013 at 4:30 pm
None of those is anything to do with a server's overall health. SQL Server doesn't really have such a thing built in. But, the closest you can get to it is to right click on the instance and choose 'Activity Monitor'. That will show you what is currently occurring within the system, to a degree, at a high level.
To really learn how to diagnose your system and it's status, I'd suggest starting with the book Troubleshooting SQL Server[/url]. You can download a copy for free or purchase a paper copy.
"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
December 20, 2013 at 7:43 am
Nice, thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply