SQL server 2000 to SAN
-
Hi to all,
In a few weeks our SAN will be operational and we have to move our data files to it. Basically this is just a copy past action from server to LUN, but I wonder if there are more detailed action needed (to upgrade performance such as I/O matters, backup, log files, log shipping, disaster management etc etc)?
And how to handle the OLAP environment which is based on some of our OLTP database?
And how to deal with high availability clusters?
Who has any experience or where can i find a "best practice" on this.
Microsoft and Dell are just telling me about the technical specifications but i'm more interested in the operational part.
GKramer
BTW using SQL server 2000 sp3a / evaluating SQL server 2005 ( Yukon Beta 2 )
-
just some readingstuff.
http://www.sqlservercentral.com/columnists/awarren/shouldyoubuyasan.asp
http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine_.asp
http://www.sqlservercentral.com/columnists/kpart/scalingout.asp
http://www.sql-server-performance.com/ew_san.asp
and
forum http://www.sqlservercentral.com/forums/messages.aspx?forumid=54
it works fine overhere
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
ALZDBA,
Thanks for replying, but the links couldn't expand my knowledge. The articles give an overview what it is and where you can use it for but that part I heard ( and read ) many times now.
I'm still looking for some kind of guidance / best practice which goes further as the reallocation of the data and logfiles.
GKramer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply