-
Recently Browsing 0 members
- No registered users viewing this page.
-
Similar Content
-
Admin of an anarchist Mastodon server raided by FBI, insecure user data gets seized 1 2 3
By zikalify,
- mastodon
- anarchists
- (and 9 more)
- 51 replies
- 6 views
-
WD Red Plus 10TB and 6TB NAS HDDs available at discounted prices on Amazon
By Fiza Ali,
- amazon
- amazon deals
- (and 10 more)
- 6 replies
- 3 views
-
Distributed SQL: The architecture behind MariaDB Xpand — Free Whitepaper
By News Staff,
- ebook offer
- sponsored
- (and 4 more)
- 0 replies
- 6 views
-
- 0 replies
- 7 views
-
- 8 replies
- 1,943 views
-
Question
benplace
I wasn't sure where to post this but I have a question for all you DB administrators out there.
I have an old Microsoft SQL server that, for financial reasons, I cannot replace until later in the year. The OS, DB and temp files are on one 10k RAID 5 array (I didn't design it) The server is getting a disk bottleneck currently. Disk active time pegging out at 100% and slow performance.
It has two x8 PCI express slots on it and I am thinking of putting two x8 ssd cards in and moving my database to that.
My question is this, would performance be better if I made the two drives stand alone, with the DB on one and the temp on the other and then replicated data in real time to another on site server for redundancy or if I just made them one mirrored array (RAID 1) using windows for redundancy with both the DB and tempdb on it?
Link to comment
Share on other sites
5 answers to this question
Recommended Posts