Viewing 14 posts - 1 through 14 (of 14 total)
try turning your virtual ram off. Keep every thing in ram.
Test your Ram using memtest89
July 19, 2008 at 11:44 am
Driver may be a problem. Install the latest patch for Oracle There a bug with path that have"(x86)" in them.
DTS Package will require 32 drivers. Link server will require 64...
April 30, 2008 at 6:04 pm
I would do this.
If you are going to loss a million dollars a day Then
Billing System and Catalog
Cluster in Europe, Active / Passive
Or
Mirroring with client redirect (ADO 2.0)
Billing...
March 31, 2008 at 11:46 am
Read this article from Microsoft.
"Physical Database Storage Design"
http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx
There is nothing wrong with DAS. It is way cheaper.
SQLMAG.COm Search
DAS
or
Pare Down and Power Up
and
Jim gray and microsoft
March 25, 2008 at 11:28 am
This may help
http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
SQL Server Urban Legends Discussed
I have been answering questions on two of the most misunderstood ‘SQL Server Urban Legends’ frequently again so I decided to make...
March 25, 2008 at 8:55 am
Yes it can, but you have to be a programmer.
You have a SSIS package that an SQL agent job calls every hour.
Does File exist, NO, exit.
Else yes.
Is file Processed? if...
March 24, 2008 at 9:33 am
I would say a SAN or NAS over a DAS, because to model DISK IO is a little hard.
I would look for a system that will let me expand a...
March 24, 2008 at 9:26 am
I say it depends.
If the data will fit in a row or less than 8K I might put it in the same File,
But if the data is large I...
March 24, 2008 at 9:05 am
SQL Server Databases object Transaction/sec doesn't measure activity unless it's inside a transaction. SQL Server General Statistics Batch Requests/sec measures all batches you send to the server even if they...
March 10, 2008 at 7:19 am
You can create some very complicated LUN on a SAN I might have 2 disk from tray 1
5 disk from tray 3
3 disk from tray 7
to make a raid 1_0...
March 7, 2008 at 8:19 am
A major architectural problem!!!!!!
This is what you need.
x64 SQL2005 Enterprise.
x64 Windows server 2008
4 or 8 7000 serious quad core xeon processors 16 or 32 cores
64 GB of Ram
A massively...
March 6, 2008 at 4:52 pm
This is a great thread.
Every one has seen the pain point of SAN or System admin designing storage by size and not IO, Disk latency, Bytes transferred, and work load.
We...
March 6, 2008 at 4:38 pm
Forget the rule of One LUN or File to one Processor. Is that the StarWars Sith rule of something:) That was an old SQL 2000 theory.
In 2005 an since the...
March 6, 2008 at 4:15 pm
I have done 3 project like this allready. It can be a nightmare.
Your SAN, NAS, DAS vender will work with you to spec out the storage.
They will base line...
March 6, 2008 at 3:55 pm
Viewing 14 posts - 1 through 14 (of 14 total)