FAQs

1. How to check currently working environment i.e. cluster or non-cluster ?

  • We can identify using server properties or by using following command
  • SELECT  SERVERPROPERTY('isclustered')
  • 0 for non cluster and 1 for cluster

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Subscribe to: Posts (Atom)

SQL Server Error Logs

* Error Logs maintains events raised by SQL Server database engine or Agent. * Error Logs are main source for troubleshooting SQL Server...

SQL Server DBA Training

SQL Server DBA Training
SQL Server DBA
  • Database Tuning Process
    Database Engine Tuning Advisor Database Engine Tuning Advisor is a client physical database design tuning tool that you can run either ...
  • Scripts
    WMI Error Solution Copy the following script in notepad and save with "wmi.bat" Double click on the file, WMI service is insta...