[NTSysADM] RE: Does Separating Data and Log Files Make Your Server More Reliable?

[Webster]

>From the comments, I gather it is not about speed, nor performance, nor 
>reliability. At least that is how I am reading the article and comments.


Webster

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Kennedy, Jim
Sent: Monday, June 26, 2017 11:55 AM
To: NT Issues (ntsysadm@lists.myitforum.com) 
Subject: [NTSysADM] RE: Does Separating Data and Log Files Make Your Server 
More Reliable?

I never viewed it as a reliability decision, but as a speed/performance 
decision.

From: listsad...@lists.myitforum.com 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Webster
Sent: Monday, June 26, 2017 12:30 PM
To: NT Issues 
(ntsysadm@lists.myitforum.com)
Subject: [NTSysADM] Does Separating Data and Log Files Make Your Server More 
Reliable?

I had always been told to separate everything in SQL Server.

https://www.brentozar.com/archive/2017/06/separating-data-log-files-make-server-reliable/


Webster

[NTSysADM] RE: Does Separating Data and Log Files Make Your Server More Reliable?

[Michael B. Smith]

You know this answer Web... as a consultant, the right answer to any technical 
question is "it depends".

What kind of storage is it? SAN? NAS? JBOD? SSD? RAID? FC?

What's the I/O pattern? Serial? Random?

What's the IOPS requirement vs. the IOPS available?

What's the real IOPS load? (you probably won't be able to get this one.)

What's the backup plan? Or the replication plan? Or the availability group 
plan? All of the above?

What is the organization's sensitivity to downtime?

So... back in "the day", with small disks, you absolutely should separate 
everything: OS on one disk (or RAID-1, the I/O pattern is more or less random 
with a real hot-spot on the paging file), Data on another disk (or RAID-1, data 
is random), and Logs on the third disk (or RAID-1, I/O pattern is serial and 
the blocks are large).

I wouldn't ever do that today. I'm gonna put two SSDs on an expensive RAID-1 
controller and backup to the cloud (private or public or hybrid is irrelevant). 
Nobody cares about the I/O pattern on SSD and in this case, adding logical 
volumes to the physical RAID just complicates life for very little real 
advantage (there is a potential real advantage if you have an application go 
amuck and begin to generate TBs of log files - but you should have monitoring 
as well).

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Webster
Sent: Monday, June 26, 2017 12:30 PM
To: NT Issues (ntsysadm@lists.myitforum.com)
Subject: [NTSysADM] Does Separating Data and Log Files Make Your Server More 
Reliable?

I had always been told to separate everything in SQL Server.

https://www.brentozar.com/archive/2017/06/separating-data-log-files-make-server-reliable/


Webster

Re: [NTSysADM] RE: Does Separating Data and Log Files Make Your Server More Reliable?

[Rene de Haas]

For both reasons.

Op 26 jun. 2017 19:35 schreef "Rene de Haas" :

> Used to do that for exchange as well.
>
> Op 26 jun. 2017 19:02 schreef "Kennedy, Jim"  >:
>
>> I never viewed it as a reliability decision, but as a speed/performance
>> decision.
>>
>>
>>
>> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.myitf
>> orum.com] *On Behalf Of *Webster
>> *Sent:* Monday, June 26, 2017 12:30 PM
>> *To:* NT Issues (ntsysadm@lists.myitforum.com)
>> *Subject:* [NTSysADM] Does Separating Data and Log Files Make Your
>> Server More Reliable?
>>
>>
>>
>> I had always been told to separate everything in SQL Server.
>>
>>
>>
>> https://www.brentozar.com/archive/2017/06/separating-data-
>> log-files-make-server-reliable/
>>
>>
>>
>>
>>
>> Webster
>>
>

Re: [NTSysADM] RE: Does Separating Data and Log Files Make Your Server More Reliable?

[Rene de Haas]

Used to do that for exchange as well.

Op 26 jun. 2017 19:02 schreef "Kennedy, Jim" :

> I never viewed it as a reliability decision, but as a speed/performance
> decision.
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Webster
> *Sent:* Monday, June 26, 2017 12:30 PM
> *To:* NT Issues (ntsysadm@lists.myitforum.com)
> *Subject:* [NTSysADM] Does Separating Data and Log Files Make Your Server
> More Reliable?
>
>
>
> I had always been told to separate everything in SQL Server.
>
>
>
> https://www.brentozar.com/archive/2017/06/separating-
> data-log-files-make-server-reliable/
>
>
>
>
>
> Webster
>

[NTSysADM] RE: Does Separating Data and Log Files Make Your Server More Reliable?

[Kennedy, Jim]

I never viewed it as a reliability decision, but as a speed/performance 
decision.

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Webster
Sent: Monday, June 26, 2017 12:30 PM
To: NT Issues (ntsysadm@lists.myitforum.com)
Subject: [NTSysADM] Does Separating Data and Log Files Make Your Server More 
Reliable?

I had always been told to separate everything in SQL Server.

https://www.brentozar.com/archive/2017/06/separating-data-log-files-make-server-reliable/


Webster

[NTSysADM] Does Separating Data and Log Files Make Your Server More Reliable?

[Webster]

I had always been told to separate everything in SQL Server.

https://www.brentozar.com/archive/2017/06/separating-data-log-files-make-server-reliable/


Webster

[NTSysADM] Another busy weekend at Webster's Lab

[Webster]

http://carlwebster.com/citrix-xenappxendesktop-7-8-documentation-script-update-version-2-05/

http://carlwebster.com/citrix-xenappxendesktop-7-x-documentation-script-update-version-1-36/

http://carlwebster.com/microsoft-active-directory-documentation-script-update-version-2-15/


Thanks


Carl Webster
Citrix Technology Professional
http://www.CarlWebster.com
The Accidental Citrix Admin

RE: [NTSysADM] This is fairly disturbing...

[Kennedy, Jim]

Yea, we have to view what is said on the register with caution.  They post a 
lot of good stuff, but too often they over play things.

-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Kurt Buff
Sent: Sunday, June 25, 2017 1:48 PM
To: ntsysadm
Subject: Re: [NTSysADM] This is fairly disturbing...

Looks like this was overblown - what a surprise:
https://www.betaarchive.com/forum/viewtopic.php?t=37283

On Sat, Jun 24, 2017 at 4:48 PM, Michael B. Smith  wrote:
> Eeeeh
>
> I think that most of this has been available elsewhere, for quite a while.
>
> -Original Message-
> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] 
> On Behalf Of Kurt Buff
> Sent: Saturday, June 24, 2017 11:25 AM
> To: ntsysadm
> Subject: [NTSysADM] This is fairly disturbing...
>
> http://www.theregister.co.uk/2017/06/23/windows_10_leak/
>
>

[NTSysADM] RE: Ot chrome book class

[Kennedy, Jim]

Check with your/her local public school.  We offer classes all summer for 
adults in conjunction with the local YWCA.

-Original Message-
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of David McSpadden
Sent: Sunday, June 25, 2017 5:57 PM
To: ntsysadm@lists.myitforum.com
Subject: [NTSysADM] Ot chrome book class

My mother in law has a chrome book and very little skills.
Any direction for video classes on general pc use and chrome book usage would 
be awesome.

Sent from my iPhone
This e-mail and any files transmitted with it are property of Indiana Members 
Credit Union, are confidential, and are intended solely for the use of the 
individual or entity to whom this e-mail is addressed. If you are not one of 
the named recipient(s) or otherwise have reason to believe that you have 
received this message in error, please notify the sender and delete this 
message immediately from your computer. Any other use, retention, 
dissemination, forwarding, printing, or copying of this email is strictly 
prohibited.

Please consider the environment before printing this email.