Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Problems Regarding SQL Server Installation

Posted on 2000-02-15
7
Medium Priority
?
221 Views
Last Modified: 2012-05-04
It is recommended that while installation of SQL Server if there is any "Disk Caching Controller" then disable it.

First I don't understand this  "Disk Caching Controller" , Do they talk from Hardware perspective or from Sodftware Perscpective.

Also I want to know about this  "Disk Caching Controller" in detail if possible.

If there is any site?
0
Comment
Question by:ShehzadMunir
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 9

Expert Comment

by:david_levine
ID: 2522447
The reason is most likely because SQLServer has it's own caching and wants to protect you in case of a failure. If for some reason, you have a disk failure or loss of power between when SQLServer thinks it physically wrote something to disk and the disk caching controller wrote something, you could lose those changes to the database.

Not a real big concern though so don't sweet it that much.

David
0
 
LVL 1

Expert Comment

by:vandamme
ID: 2524314
Usually, a "Disk Caching Controller" is referring to Hardware.  When applications write to your hard drive, these controllers try to optimize your write time by holding the information in a cache until it has a full page\sector\(whatever) to write.  This helps your I/O, but if you lose power you lose any data in this cache.  That's why SQL Server wants you to turn it off.  It includes mechanisms which keep track of what data is actually written to the drive.  The two could interfere with each other, and cause data loss.  That's why they want you to disable it.  But like David said, it's no big deal, especially if you keep current backups which all "GOOD" DBAs do...
0
 

Author Comment

by:ShehzadMunir
ID: 2529952
Thanks a lot. It helped me out.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 9

Expert Comment

by:david_levine
ID: 2530923
So give one of us the points so the question is closed out.

David
0
 

Author Comment

by:ShehzadMunir
ID: 2545496
Adjusted points to 20
0
 
LVL 4

Expert Comment

by:wqw
ID: 2547817
ungrateful bastard?

(i'm a non-english speaking:-))
0
 
LVL 1

Accepted Solution

by:
vujos earned 80 total points
ID: 2558090
Hi,

Some starting points :

1) Disk Caching Controller is hardware
   tahat is usaly used in combination  
   with RAID controllers (like
   MYLEX, SERVERRAID, ADAPTEC, DPT and
   many more).

2) Quality of Disk Caching Controller
   is measured in quality of Caching
   algoritam and quantity of on board
   RAM.

3) One of the parameters to look for (
   in the database world is battery
   backup). If database server app
   writes data to the disk (via cache
   controller without battery backup)
   data is stored  initialy
   in the controller memory,and not
   physically written on to the
   disk. If the failure of the hardware
   heppened in that moment data loss
   and logical incosistency will occur.

4) In order to avoid this select
   /DISK controller that does not
   have caching controller built in
   or in the controller setting
   disable ("Write Back") cache and
   enable ("Write Trough") mode.

Good reading for this also Microsoft SQL Server Administrators Companion on the page 766 and 767 under "Error 605".

Hope this is the complete answer.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question