Thanks for you replies. I was trying to find what Microsoft recommends as far as the number of drives one should have for Azure VM's for sql server. Looked at...

Well, we have multiple app servers that process the messages in the queue as the volume of messages is large we use multiple servers to read from the queue table....

Thanks for the reply. Unfortunately, we don't have any large drive on the target server.

Don't know if the fact that this database just has one table that...

Thanks a lot for the detailed list of things to do for the migration.

Actually 5 of the 6 databases we are migrating are less than a Gig and the 6th...

It is on SQL 2012. The inserts do have several large varchar(max) columns being inserted and we wanted to make sure that it will handle 40 to 50,000 transactions an...

So Eirikur said that drives, file groups and configuration would have an impact on performance.

We have 4 drives, one has data (mdf) files, second has log (ldf) files, third has...

Thanks Alan!

This will certainly help.

BVip.

Thanks for the clarification Gail, appreciate your help.

Thanks Koen!

All this is new to me and I was not sure I understood: "the data for most is memory-only, no persistence.".

Does this mean the data needed for the DMV...

Thanks for the replies Gail and Koen!

So from what I understand based on what you have said, all the basic sql scripts to create the DMV's are in the system...

Just wanted to add that this is a pretty much Microsoft shop. So the datbases are going to be SQL Server 2008, the application will be mostly c# code. For...

Just need to confirm one other thing. We are going to create a new cluster environment with sql 2005 having two nodes, let us call it C1. We already have...

Thanks for guiding me to that article. It looks helpful for dealing with identity column replication.

Vip.

Andy,

I am in the process of upgrading our Prod sql Server clustered box from Sql Server 2000 to 2005. We have bought new hardware and are planning to create a...