Snapshot isolation level would help and will not cause blocking.

But again there is a resource overhead associated with Snapshot isolation level and that is the tempdb,

Snapshot isolation level uses tempdb...

SQL Server uses the Windows concepts of Memory Management.

Reserved/Committed/Free.

The 14GB of Target Pages is the reserved amount of virtual memory that SQL Server has used so that other processes...

Not sure when you say one cluster group.

But however if its a 2 node Cluster then you may think of having 2 instances in Active-Active or Active-Passive.

Each of the SQL...

You can use VB.NET scripting

On the Setup Screen of SQL Server 2005 ==> Components to Install ==> Select "SQL Server Database Services" And Click on Advanced.

Expand Database Services ==> Data Files and Click on...

I would suggest using the Reports section of SQL Server 2005 to monitor the performance of the SQL Server at run time.

For Example the following Reports

1> Server Dashboard

2> Performance :...

Turn off the SQL Services using Cluster Administrator

SQLIOSim is the best tool from Microsoft to tackle read and write IO Errors pertaining to databases.

SQLIOSim tackles the Lost Write and Stolen Read problem

For full discussion check :...

Updating system tables is not supported in sql server 2005.

Your best bet is to restore from a valid SQL backup. However if you do not have a backup.

1> First...

Check the Following Article

AWE-enabled SQL Server 2000 may take a long time to start

http://support.microsoft.com/kb/329914/en-us

Use the workaround

{

On a Windows 2000 cluster, if the time that the operating system...

Monitoring Total and Target server memory would let you know what is the allocation / deallocation rate of the server.

However a good way is to understand Memory Manager on...

What is the startup Account of SQL Server ??

Check the Permissions tab on the Folder E:\MSSQL7\Data and see to that the Startup Account of SQL Server has Full Permissions on...

You can add me at sumit_vrce@yahoo.co.in

Give the SQL Server build and Windows Build.

Also paste the Checkdb results and any Error Messages in the ErrorLogs...

Try to find out if there are any stacks generated.

Please send the...

There is a way to retrieve the Data but could result in Data Loss.

I would suggest resort to LAST KNOWN GOOD BACKUP. But if there is no backup or old...