Re: Separate Data and Log files
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/06/05
- Next message: Miha: "Problem with installation"
- Previous message: Keith Kratochvil: "Re: Where do you enter licensing info"
- In reply to: Tom W: "Re: Separate Data and Log files"
- Next in thread: Tom W: "RE: Separate Data and Log files"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 6 Jan 2005 13:37:34 -0500
Those numbers don't really mean much by themselves other than the cachehit
ration. If it is only 80% you are most likely either way low on memory or
simply have a lot of untuned queries. MS does not have a preferred SAN
vendor per say although if you are going to cluster it you need to ensure it
is on the Clustering HCL. Most of the modern SAN vendors (EMC, Hitachi,
Fugitsu etc.) will work fine given a proper configuration. I am not sure
what type of document you are looking for but usually the configuration of a
SAN on a higher end system requires a fair amount of coordination with the
SAN vendor.
-- Andrew J. Kelly SQL MVP "Tom W" <TomW@discussions.microsoft.com> wrote in message news:F0CA38B9-5D31-4454-9B5D-B628690EBBAC@microsoft.com... > The servers are typically running about 400 transaction/sec, about an 80% > data cache hit and cpu utilization of aroun 40%. There is moderated > writes. > Does Microsoft have anything documented or maybe even some SAN vendor? > > > > "Andrew J. Kelly" wrote: > >> It is quite possible that a SAN can mask the need to separate the files >> due >> to large amounts of cache. But that still depends on what you are doing, >> how >> many transactions etc. I have seen SAN's in which the files were not >> segregated and there were performance issues but it all depends. >> >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Tom W" <Tom W@discussions.microsoft.com> wrote in message >> news:DE458441-263C-43AF-9A17-E8C719283AD9@microsoft.com... >> > Is there a documented information about separating the data and log >> > files >> > pertaining to physical disk layouts. How much relevance is this >> > documentation with newer SAN technologies where there are large buffer >> > caches. Because my understanding is that the SAN units notifies the >> > server >> > that the data is written to disk when in actuality it is still in cache >> > waiting to be written to disk. >> > >> > Tom >> >> >>
- Next message: Miha: "Problem with installation"
- Previous message: Keith Kratochvil: "Re: Where do you enter licensing info"
- In reply to: Tom W: "Re: Separate Data and Log files"
- Next in thread: Tom W: "RE: Separate Data and Log files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
