- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- ProLiant Servers (ML,DL,SL)
- >
- Re: SQL 2000 Low Perfomance
Categories
Company
Local Language
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
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
Community
Resources
Forums
Blogs
- 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
тАО06-04-2007 07:14 PM
тАО06-04-2007 07:14 PM
SQL 2000 Low Perfomance
on ML370 G5 finished with trable
MSSQL 2000 server have a low perfomance
(e.g. 3000 transactions(simple INSERT) doing
above 20 sec)
Version Of SQL 8.00.2187(SP4 with hot fix)
How fix this trable?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-05-2007 03:54 AM
тАО06-05-2007 03:54 AM
Re: SQL 2000 Low Perfomance
How do you have the Disk setup? Types of RAID? how many drives? How are your databases setup? Are they on seperate Drives?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-05-2007 04:00 AM
тАО06-05-2007 04:00 AM
Re: SQL 2000 Low Perfomance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-05-2007 02:22 PM
тАО06-05-2007 02:22 PM
Re: SQL 2000 Low Perfomance
RAID 5 Level(Speed
Read 400 MB/s Write 60 MB/s)
Test Script write in Query Analyzer
(Login: sa)
-------------------------------------------
declare @count int
select @count =3000
Test_Next:
INSERT INTO [TestTable] (Col1,Col2) VALUES (1000,'156')
select @count =@count - 1
if @count <> 0 GOTO Test_Next
--------------------------------------------
doing above 20 sec.
Why have Long Parse and Compile Time ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2007 09:33 PM
тАО06-07-2007 09:33 PM
Re: SQL 2000 Low Perfomance
as of view for performance raid-5 is not the obvious choise. Especially if also the transactionlog is on this volume.
NB! you didn't answer the previous question about writeback cache present or not on the controller.
Many threads on this forum can be found where bbw-cache option is suggested (as first option!) for improvement.
Th system has to wait for the transction to be written to disk, without cache this isnt very fast especially with raid5, for with the controller has to perform multiple i/o.
You could also improve by using separate raid-1 (1+0) volumes for data and transactionlog.
More configuration details are missing (number of processors, memory, sql standard or enterprise)
Pieter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2007 08:09 AM
тАО06-12-2007 08:09 AM
Re: SQL 2000 Low Perfomance
RAM 4GB
SQL 2000 Standard
I do experiment: create database on IDE hard
on ML370 G5. MSSQL 2000 server work perfect!!!
You are right, may be problem in cache ratio
Into ArrayConfigaration Tools i found only one values of ratio: 100% read and 0% write
Why?
Smart Array Controller P400 have 256MB into
my configuration (FirmWare 2.08)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2007 08:20 AM
тАО06-12-2007 08:20 AM
Re: SQL 2000 Low Perfomance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2007 10:41 PM
тАО06-12-2007 10:41 PM
Re: SQL 2000 Low Perfomance
If this option is not present you only have read cache.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2007 10:49 PM
тАО06-12-2007 10:49 PM
Re: SQL 2000 Low Perfomance
the 256 MB model is not equipped with BBWC
HP Smart Array P400 Controller HP Smart Array P400/256MB Controller 405132-B21
HP Smart Array P400/512MB Controller with BBWC 411064-B21
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-13-2007 05:46 AM
тАО06-13-2007 05:46 AM
Re: SQL 2000 Low Perfomance
Can BBWC module installation on SmartArray Controller
raise low perfomance of SQL Server 2000 Standard?
PS
Perfomance of MSSQL 2000 server on RAID 0
increase at 35% in comparison of RAID 5
(3000 transactions[simple INSERT] doing
above 14 sec).
Have SA p400 special tuning (except cache ratio)?