Thank you both.  I thought I had done a good job with my performance tuning.  When I saw those connections with high CPUtime and Diskio, it made be question my...

Hello,

It is a production floor with several pcs running the same application.  Each time an employee scan a product at their station, the database keeps updated.

So...

Yes, this is what I was referring to also.

I assumed it was adding it as a C drive.  I am not sure now.  However, if thought it suggests...

The configuration does advise but only at the 1 TB level.  It gives you up a TB but this is allocated to c drive.  If you want additional drives, you...

Again, I really appreciate your insight.  I really think the geo replication is going to work for us.

Thanks.

Thanks Grant.  I really appreciate your insight. 

No, I get it with the readable secondary, I can have my reports look to a readable secondary.  That is a big...

Grant,

As I have been studying GEO replication, I see it as mainly a failover situation.

1.  If you have a primary in the north region, you can set up...

Grant,

Thanks for all of your help.

I appreciate it!

Tony

I do like the active geo replication, but one finally question on that.

How do I access the secondary reporting when the secondary has the same name as the...

After doing some studying, it may be that active geo replication would be a solution.

1.Create a primary database in central region.
2. create a secondary database in east...

I was thinking of setting up SQL Server in Azure VMs.  But after Grant's reply, I may need to rethink that.

If I understand right, we are located in...

This post was a while ago, but I thought I would reply.

Have you heard of data sync services?  I am looking to do the same thing.  I have...

I tried connecting inside the network with the same public IP.  That didn't work.

I checked all of the TCP protocols and all are enabled.

I am thinking...

Sue,

I was able to ping the server from the pc.
I am testing telnet now.

Thanks.