I'm relatively new to SQL server development in a non-collegiate scenario, so i will try to be as concise as possible.
Our production server handles a lot of queries every day from many sources(sales dept.,our website, amazon, reporting, etc...). When the server begins to noticeably slow we have found that the server resources aren't maxing out. The data choke point seems to be the hard drive read/write speed.
(This is how it was explained to me, and I have been given the task of researching this possible solution.)
My question is: can you use transactional replication to replicate a database on another hard drive within the same server? We want to do this to offload all our reporting to the separate hard drive so the main hard drive is only handling orders without replacing hardware or building a second server. Sort of like an internal data warehouse.
Any help is much appreciated.