Hey good people,
Haven't been around much lately and have had to wear a few new hats at work.
Long story short, I was approached yesterday by our Metaframe guru who wants to move the SQL Server data store for an old, large Metaframe XPe farm. This farm serves several mission critical clincal applications in a large health care system.
I suppose my main question from anyone who has done this is, what are the pitfalls of moving a production data store? Also, what are the most common bottlenecks on data stores and what's the best way of avoiding them? I know very little about the server where the store is located as our web developers are in charge of this, but am hoping to get a look at it early next week. Right now, all I know is that it's a clustered SQL 2005 that pretty much handles all the back end stuff for our web portal.
Thanks in advance...hope you all have a great Friday!
My hovercraft is full of eels.