March 17, 2009 at 10:30 am
Hi All,
I have some questions about SQL 2005, and I thought instead of having individual posts, I combine it all into one.
1.How can one complete regressions testing whilst trying to install a service pack for SQL 2005.
2.In SQL 2005, is there anything like load balancing like there is with Oracle RAC where one can distribute load amongst servers.
3.What is the best way to replicate production/testing environment, is it backup/restore or are there any smarter ways of doing this eg SAN.
4.If a user rings up to say the SQL instance is a little slow, what would be your approach and what lines of enquiries would you take.
Thanks very much guys.
March 17, 2009 at 11:39 am
Why would you be in the middle of both regression testing and installing a service pack on the same server at the same instant? Or am I misunderstanding your question?
SQL Server doesn't really, to my knowledge, have RAC-type load ballancing. One of a few areas where it's still catching up to Oracle.
I do my synchronization from prod to test/dev by doing a backup-transfer-restore cycle. Works pretty well. I have a proc that takes input parameters of server name, database name, point-in-time to restore to, and target database name. Does all the work for me.
I'd start by asking what they mean by saying the database server is a bit slow. Does that mean they can't get into a web page, or have they actually measured something? After that, the decision tree branches out pretty rapidly in a lot of different directions, ranging from having the network ops check routers to beating up devs who took something to production they shouldn't have, to running for a fire extinguisher or calling 911. It really depends a lot on what they mean by "slow" and what comes up from that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply