Viewing 15 posts - 1 through 15 (of 18 total)
the main specs on the two new servers that just came in:
Dell R710
128GB Memory (16*8GB) 800 MHz dual Ranked RDIMMs for 2 processors, optimized
2 - Xeon E5630 2.53 Ghz, 12M...
April 27, 2010 at 9:47 am
Steve Jones - Editor (4/27/2010)
289 files? Do you mean 289 ndf files?
No, Log files.
Someone asked how big the transactions are, and the closest thing I could think of was the...
April 27, 2010 at 9:36 am
matt stockham (4/27/2010)
April 27, 2010 at 9:19 am
It is 2005 64bit Standard Edition.
Since we use log shipping I can tell you the last 72 hours of logs - 2.53 GB (2,720,354,304 bytes) 133 Databases
A client that might...
April 27, 2010 at 8:45 am
David Bird (4/27/2010)
How many applications will be using these databases?
one application - we build software for political campaigns. Each database is a political client.
April 27, 2010 at 7:50 am
Robert Davis (4/26/2010)
You do understand that the recommendation to limit the number of mirrored databases is due to thread...
April 27, 2010 at 7:48 am
Robert Davis (4/23/2010)
400 databases? On how many servers?
Total of 2 servers (now) one main and one mirror. Right now we have 130 databases. Everything we read tells my...
April 25, 2010 at 9:02 am
My boss has decided on a mirror. We have found an ISP to co-locate in that has two data centers with a LAN between them that is fiber and...
April 23, 2010 at 12:38 pm
matt stockham (4/13/2010)
* how long can you afford to be down?* how much data loss can you afford?
Very Little - 2-3 minutes up to last 20 transaction per client.
matt stockham...
April 13, 2010 at 4:14 pm
I agree about hiring an expert. But I don't know who we could trust to give us correct information on the options.
Any suggestions in our area? USA Minnesota -...
April 12, 2010 at 9:15 am
Robert Davis (4/10/2010)
April 11, 2010 at 11:52 am
The concern on cluster is we have the one device (the external Hard Drive Unit) as a fail point. It seems to be just a fancy piece of hardware...
April 10, 2010 at 3:02 pm
CirquedeSQLeil (4/9/2010)
Unless absolutely necessary I would not mirror that many databases. I would pick and choose which databases were to be mirrored.
Maybe 10-20 percent are not used hourly, the...
April 10, 2010 at 2:56 pm
Edogg (4/9/2010)
Why not both?
Cost!!
Edogg (4/9/2010)
Clustering is primarily for high availability and not disaster recovery unless you plan to geocluster/multisite cluster. You only have one set of data on disk.
This...
April 9, 2010 at 3:57 pm
Thanks.
Could you expand on your reasons.
April 9, 2010 at 3:38 pm
Viewing 15 posts - 1 through 15 (of 18 total)