send us the log for following queries:

select * from sys.dm_db_mirroring_connections

select * from sys.database_mirroring

select * from sys.database_mirroring_endpoints

select * from sys.database_mirroring_witnesses

This is what I don't understand:

"ROWS_PER_BATCH should approximately the same as the actual number of rows"

It means that all the rows would be in the same batch. And we are...

Thanks for your prompt answers. I have drafted my questions as follows: Can anyone help me with these answers?

1. What is IP1, IP2 and IPAll in n\w configuration?

2. How...

This is granular arrangement from sql server architects. We can't change page size.

Why This is 8k?

1 MB = 128 pages.

Now 1 MB = 1024

so we needed something that should...

What is the meaning of mismatched SID's Jack?

DB owner or person with sysadmin role only has perms to create DB diagrams. They can have db roles of

1. db_datareader

2. db_datawriter

BOL: Only the owner of the diagram or...

According to my understanding ROWS_PER_BATCH is same as BATCHSIZE.

The sentence in my previous post is from BOL only and when this describes 100 as batch size then it is same...

Do you mean that if we set compatibility level = 80 and then we take the backup of that DB. Later on this DB can be restored to sql server...

Thanks Gila,

My question is answered in this discussion. Great info and thanks again to Gila and others.

Just to demystify the doubts.. enterprise edition can also run on Vista... Although this is memory hog... (Gila thanks for this info)

Thanks Gila for great info.

And this is not the only server we are using. There is one more server which is as follows:

Microsoft SQL Server 2000 - 8.00.2055 (Intel...

This is really awesome information Praddep. Thanks for this. Don't we have any page footer as we have page header?

Yes this is on Vista. My TL took a decision to have this on Vista and not Microsoft sql server 2008 which we proposed. I was not able to convince...

Thanks. Following link defines well about buffer pool and cache. Should I use the files you gave me to enable /3GB switch. Can you give me any link which tells...

Thanks for your response SSCrazy and Gail.

The reason I want to do that is that my application is running very slow. I want to allocate more memory to sql server...