April 13, 2017 at 6:43 am
Good Afternoon,
I'm beginner concerning SQL server.
I have different question about Sizing, and partition on Windows.
I have done a sheet with different partition for data, log, tempdb..
Could you tell me if it could be correct for a Sql Server Install ?
Thank you very much
Anthony
April 13, 2017 at 7:56 am
Unfortunately, the only sizing information you provided was a raw number, without any kind of qualification as to whether those numbers represented kilobytes, megabytes, gigabytes, or terabytes. You also made no mention of overall transaction load in either average transaction size nor total volume thereof, so if you were hoping that asking if some number with no effective meaning was somehow "right", then you're barking up the wrong tree. You'll have to be more detailed and specific as to what your numbers mean, along with providing physical sizes for your disk volumes, as well as server cpu core and clock speed info, overall transaction volume and average size, as well as a more detailed explanation of what, exactly, "Read intensive" and "Write intensive" mean.
Also, what kind of application is intended to operate in this environment. How many users? Do you have a DR plan? There's a lot of questions to ask, and we have next to nothing in the way of details.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
April 13, 2017 at 11:46 am
sgmunson - Thursday, April 13, 2017 7:56 AMUnfortunately, the only sizing information you provided was a raw number, without any kind of qualification as to whether those numbers represented kilobytes, megabytes, gigabytes, or terabytes. You also made no mention of overall transaction load in either average transaction size nor total volume thereof, so if you were hoping that asking if some number with no effective meaning was somehow "right", then you're barking up the wrong tree. You'll have to be more detailed and specific as to what your numbers mean, along with providing physical sizes for your disk volumes, as well as server cpu core and clock speed info, overall transaction volume and average size, as well as a more detailed explanation of what, exactly, "Read intensive" and "Write intensive" mean.Also, what kind of application is intended to operate in this environment. How many users? Do you have a DR plan? There's a lot of questions to ask, and we have next to nothing in the way of details.
Good Evening,
Thank you for your reply
I have modify sheet with new element.
It's important to notice that it's a new install.
- Application / software : Asset Management
- 4 VCPU
- 8 GO RAM
- 1 instance with 1 database
- Database size : 4 GB
- 50 users simultaneous
- Windows Server 2012 R2
- SQL Server 2012
Backup :
- dbname transaction : each 1 hours
- One full each night
Question :
1) Is it interresting to separate (different partition) datafile / log file / tempdb file / tempdb log file ?
If yes,, is it interessting to separate also (different partition) datafile MDF with datafile NDF ?
Exemple :
Separate D:\data\dbname_data1.mdf with D:\data\dbname_data2.ndf and with D:\data\dbname_data3.ndf ?
So result could be :
D:\data\dbname_data1.mdf
E:\data\dbname_data2.ndf
F:\data\dbname_data3.ndf ?
What is best practice concerning quantity of *.ndf (1, 2.more) and best practice for size / autogrowth ?
2) Because I don't know how database involve (increase) in time, I don't kwow how I can size different parition (D, E, F...)
3) And I don't know what is best practice to size / autogrowth datafile, log, tempdb... ?
Thank you very much
Anthony
A beginner in SQL Server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply