Hi,

KB article provided by my colleague is good one and apart from that in order to understand Blocking i will suggest you to collect Profiler with below counters.

Locks:

...

Hi,

There is another MS utility named as Tablediff which will compare data between 2 tables. Please check below link.

http://msdn.microsoft.com/en-us/library/ms162843.aspx

Regards

GURSETHI

Hi,

I am totally in line with Abhay's findings. We should try running this query using MAXDOP 1 hint. More over out of those 9 Thread only 4 of them are...

Hi Ram,

Please write in detail with this current set of lines we are not able to understand what is required here.

Otherwise yes in SQL Server we cannot archive the backups....

Hi Dinesh,

Dear your question is realy not clear. But if i go by it then please check below link in Books On Line for Database States.

BOL Link:

=======

Database States

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/b7f1f111-ca73-4a89-b567-a98d64d6ecb3.htm

MSDN Link

=========...

Hi Mohammad,

Good question, realy a good question. If we right click and open properties it will show us Initial File size but there is no DMV which will tell it....

Cool,

Thanks for this information. Now further to it are we able to connect to Master thru Query Window and run SELECT * FROM SYS.SYSPROCESSES?

In the output are we able to...

Hi,

I agree with Lynn if we need Point in time data then this methedology is not good. Either you can run your reports with Production server or I must say...

Hi,

So from your question what I understood is as below.

1) Initially we were having 2 node cluster Node A & Node B.

Node A was active...

Thx for reply,

If possible can u provide more details about the job? Id this job is having multiple steps then whether first step completes or not (means if its updating...

Hi,

By looking on the output I believe that SPID 57 is the one which is running the job (Correct me if I am wrong). Now the wait type it is...

Hi,

We can also query a DMV which will tell how much %age a specific query has done.

SELECT SESSION_ID, percent_complete, estimated_completion_time FROM SYS.DM_EXEC_REUQESTS

Regards

GURSETHI

Hi,

Sorry but this link is not available its failing with error "Service Unavailable".

http://msmvps.com/blogs/clustering/archive/2005/07/17/57916.aspx

Regards

GURSETHI

Hi,

As far as I know we can install SQL 2000/2005 & 2008 on a same cluster. The thing is one will be default instance and rest will be Named one.

Regards

GURSETHI

Hi,

Yes your are right PERFMON will not be able to give your right information so you have to go to the SAN Vendor as they have the tools to analyze...