- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- Disk Enclosures
- >
- SQL Server 7.0 Implementation
Disk Enclosures
1753974
Members
7262
Online
108811
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-15-2001 04:00 PM
тАО02-15-2001 04:00 PM
SQL Server 7.0 Implementation
I'm going live with an ML370 running NT4.0 SP6 and SOL Server 7.0 SP3 with two RAID cards in the server. The first card has two RAID 1 pairs for SO, tempdb, etc.; second set has 5 drives in RAID 5. (All drives 18G).
What I'm most concerned about is the RAID accelerator. On both cards I'll have it turned off before production, which I know will impact performance. But I'm nervous about the accelerator until I know someone else is using it without problems.
Does anyone have any info to help me address my concerns one way or the other? Your input is appreciated. Thanks!
What I'm most concerned about is the RAID accelerator. On both cards I'll have it turned off before production, which I know will impact performance. But I'm nervous about the accelerator until I know someone else is using it without problems.
Does anyone have any info to help me address my concerns one way or the other? Your input is appreciated. Thanks!
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-15-2001 04:00 PM
тАО02-15-2001 04:00 PM
Re: SQL Server 7.0 Implementation
I believe a lot of customers have been using our Array controllers (with the accelerator) with SQL and Oracle for years.
The issues Microsoft has noted with caching RAID cards has typically involved rather "dumb" cards that pretty much just cache and require the OS to do a lot of the actual work. That's not the case with our cards.
The issues Microsoft has noted with caching RAID cards has typically involved rather "dumb" cards that pretty much just cache and require the OS to do a lot of the actual work. That's not the case with our cards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-22-2001 04:00 PM
тАО02-22-2001 04:00 PM
Re: SQL Server 7.0 Implementation
The Microsoft stance on array controller caches makes an assumption to be on the safe side. You do not want the SQL Server to think that data is written to disk (when it is just written to cache) and then have your server fail. If this occurs, you have lost data. The assumption that Microsoft makes is that the array controller does not contain a battery backed write cache. On Compaq array controllers, if there is no battery backed cache, then there is no write cache available. If there is battery backup on the controller, and the battery fails, the write cache is automatically disabled. Recognizing these facts, enabling the array accelerator seems to be a no brainer.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP