January 23, 2009 at 5:43 am
I would like to improve the performance of my SQL Server 2008.
I currently used a 4 disk RAID 10 for my data, since this is a small RAID 10 array, would i be better having a 4 disk RAID 1 array ?
Thanks
January 23, 2009 at 6:43 am
Personally, I'd stick with RAID 10. The added safety is worth more than a small increase in speed.
You've collected performance data and the bottleneck is I/O and you've tuned the indexes, the queries and the data structure so that everything is performing in an optimal fashion? Usually hardware tuning is one of the last things to worry about, assuming it was set up properly in the first place.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2009 at 7:05 am
Not really sure how to tune the indexes.
I have approx 770k records in text file format, with full text indexing running.
I run a sql query to extract specific data, based on matched fields and on average it takes about 5 minutes.
I would like to improve that if possible.
If i use the GUI and search on created indexed fields, it takes about 1 second for 3k records.
The issue is that i cant always create the index in advance, so i must use method 'one'.
Thanks
January 23, 2009 at 8:02 am
Tweaking the disk, especially from RAID 10 to RAID 1, is only going to get you a marginal increase in performance. I'd concentrate on the queries, indexes (full text indexes if needed), and the structures. You're going to get more performance increase working there rather than elsewhere.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2009 at 4:52 pm
yeah I agree.
changing the RAID Level will not do too much at this point.
now adding Spindles (Disks) may give you a big improvement, but now youre talkin bucks.
Greg J
Gregory A Jackson MBA, CSM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply