SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Mount Points


Mount Points

Author
Message
Cousin Eddie
Cousin Eddie
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 35
Simply put: Is anyone using mount points in their SQL2K5 implementations? If so...what's been your experience on ease of use, performance, problems, maintainability? Thanks!
runaldo
runaldo
SSC-Enthusiastic
SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)

Group: General Forum Members
Points: 194 Visits: 566
Hi Brad

I have been using mountpoints on HPBL45 servers with no problems. Mount points againt HPXP1024SAN and EVA8000 Series. Clustered solutions only.

We have mainly used this for sharepoint db's to expand diskspace without using any more driveletters.

I have also used it during migrations to host bcp data.



Cousin Eddie
Cousin Eddie
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 35
Thanks for the reply. Performance and ease of use are two of the criteria we're attempting to evaluate so your experience is very timely.

We're engaged in a consolidation project for several clients and are considering using mount points to increase the number of instances being hosted on a server/cluster (to mitigate the problem of not having enough drive letters for the physical volumes involved) and, where the customer wants to host databases for multiple applications onto one instance, isolate storage usage so that any one set of application databases does not cause problems for other application databases when unexpected storage usage event (e.g. from an INSERT/UPDATE/DELETE query using up all of the transaction log space) occurs. Using mount points would also give us the flexibility to add space easily.

Brad
runaldo
runaldo
SSC-Enthusiastic
SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)

Group: General Forum Members
Points: 194 Visits: 566
The SAN guys told me that for disk performance the read/write I/O for SQL and Exchange where quite similar in patterns. But Fileshares where not so they tended to isolate Fileshares on own LUN's(DiskZones) and didn't use Mount points for those. Somehow they had experienced that performance-wise the mountpoints didn't deliver. In Exchange and SQL group we couldn't tell if dedicated disk with driveletter or mounthpoint - we used this scenario for sharepoint databases and when users are using browser expectations of performance drops quite significantly. I guess it's more dependandt on SAN design than on Windows/SQL performance.

I don't have any problems with translog growth. I normally tune the size of the translog the first month a new db comes into an instance. Monitor log backup size on the database and then adds about 40% for growth on the log file and set it to fixed. Only challenge I have is tempdb and unexpected behaviour when adding new db's.

-R



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search