SQL Server Performance Forum – Threads Archive
multiple instances of sql on one boxI have two db’s on one server, archive db and production db. Right now the reports are hitting the archive db and slowing down the productions db. If I install another instance of SQL on the same server, will I solve my problem. I would have the production db be in one instance, and the archive db be in the other instance. Let me know what you think. I know that moving the archive db to another server would be much better, but that isn’t an option right now due to costs. Thanks for your help, Ben
I donÂ´t think you get more performance with two instances in same box.
I think is better one instance with 2 databases than 2 instances 1 database each.
Seconding to what Kuis suggested, having two instances will not help if system is runnin low on resources. If it is not running low on reources, further investigation in configuration may be required. Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
Better to increase the physical resources on the server to attain the performance as suggested by Luis & Gaurav. And in any case if the production database is critical then always treat to differentiate archive/reporting database on other server, another good practice. BTW, post details of the H/w and database sizes. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.