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: Comments (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 ...
  • Installing and Configuring SQL Server 2008
    System Requirements * O/S                       : Windows2003 with sp2/ 2008 Server * Memory                : 1GB * CPU                 ...