Sounds like you using Windows 2003 32-bit? If so, here's the recommened settings:

1. Ensure /PAE switch is in the boot.ini

2. Ensure /3GB switch is in the boot.ini

3. Ensure paging...

Hey,

The error wouldn't get raised, as SQL Server is concerned, the I/O is completed, but in reality in cache on SAN.

By disabling the storage system LUN cache property, this will...

Hi,

This should help:

http://blogs.msdn.com/euanga/archive/2006/07/11/662053.aspx

Thanks,

Phillip Cox

You may want to invest in the following as well:

Microsoft Data Warehouse Toolkit (Wiley)

http://www.amazon.com/Microsoft-Data-Warehouse-Toolkit-Microsoft-Business-Intelligence/dp/0471267155

By Joy Mundy and Warren Thornthwaite

Hey,

This should provide some background to help you and your SAN admin.

http://russia.emc.com/techlib/pdf/H2203_MS_SQL_Svr_Symm_ldv.pdf

Thanks,

Phillip Cox

Hi,

You use whatever size server you require, but please ensure you have ample storage space on both servers and a reliable network connection between the servers for log shipping.

In addition,...

Hey,

We must remember, SAN cache is completely different from host cache, as once SAN generates an I/O completion event, as far as SQL Server is concerned, the data has been...

Here is a handy tool for this type of situation.

http://www.dependencywalker.com/

Hope this helps,

Phillip Cox

Hi,

Not sure what you're question is, but if you want to call another stored procedure from a stored procedure, just call it. This is what we call nested stored...

Hi,

Can you provide more information in terms of SQL Server usage for application?

Thanks,

Phillip Cox

Hi,

Thanks for update, but I have worked with EMC CX300 and DX3000 over the years and what your collegue is stating is the cache is not mission critical, which this...

Hi,

Ok, here's the breakdown:

1. Login = To only access SQL Server, you first must have a login to server

2. User = ...

Hi,

Worked on a project about 6 months ago and we decided to go for the HP p-Class Blade hardware, as this provided a great deal of consolidation and power in...

hey,

Just to add, you could consider following:

1. Cluster the database engine bit via an Active\Passive configuration

2. Cluster the reporting services database bit via an Active\Passive configuration

3. Network Load Balance (NLB)...

Hi,

You will not be able to access any database, while SQL Server is restoring. Once restored and if you have opted for Standby, then you will be able to...