I have SAN mapped as Raid 5 and Raid 0. I have to place Clustered Index file
(contains all clustered indexes) and Nonclustered Index file file (contains
all nonclustered indexes). Which Raid level is the best and recommended for
clustered and none cluster
ed index files to have a better performance? It is sql 2k.
Thank you,
KtfI would suggest that this is not enough information. The standard safe answ
er will be that raid 10 will give you better performance.
But if you are running a database on a EMC clarion SAN, it is possible that
you will never overflow the cache, or that the writes across 168 drives of r
aid 5 will provide excellent performance.|||Ken,
Yes it is EMC but not that many drivers. It was raid 5 and 0 already mapped
by Dell (builtin that way). I know about raid 10 but my real question is wha
t would be the best raid for clustered and noneclustered index files?
Thank you,
ktf
Showing posts with label mapped. Show all posts
Showing posts with label mapped. Show all posts
Friday, March 30, 2012
Q on Clustered and Nonclustered Index files to be on Raid
I have SAN mapped as Raid 5 and Raid 0. I have to place Clustered Index file (contains all clustered indexes) and Nonclustered Index file file (contains all nonclustered indexes). Which Raid level is the best and recommended for clustered and none cluster
ed index files to have a better performance? It is sql 2k.
Thank you,
Ktf
I would suggest that this is not enough information. The standard safe answer will be that raid 10 will give you better performance.
But if you are running a database on a EMC clarion SAN, it is possible that you will never overflow the cache, or that the writes across 168 drives of raid 5 will provide excellent performance.
|||Ken,
Yes it is EMC but not that many drivers. It was raid 5 and 0 already mapped by Dell (builtin that way). I know about raid 10 but my real question is what would be the best raid for clustered and noneclustered index files?
Thank you,
ktf
ed index files to have a better performance? It is sql 2k.
Thank you,
Ktf
I would suggest that this is not enough information. The standard safe answer will be that raid 10 will give you better performance.
But if you are running a database on a EMC clarion SAN, it is possible that you will never overflow the cache, or that the writes across 168 drives of raid 5 will provide excellent performance.
|||Ken,
Yes it is EMC but not that many drivers. It was raid 5 and 0 already mapped by Dell (builtin that way). I know about raid 10 but my real question is what would be the best raid for clustered and noneclustered index files?
Thank you,
ktf
Wednesday, March 21, 2012
Pulling trans logs from one server to anthother
I know this can be done using a bat file, but am having issues finding any
documentation.
I need to connect to a mapped drive and move trans log backups from on
server to another server so they can be applied.
Any help would be greatly appreciated.
Thanks in advance
SusanI recommend using VBScript and the Windoes Scripting Host.
here is some documentation:
[url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/ur
l]
It will allow you to create more robust scripts with error handling and
logging capabilities. Here are some examples:
[url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[/u
rl]
Search for the Scripting.FileSystemObject to get code samples.
I used it in the past with very good results. In fact, I have production
systems that depend on scripts I wrote and they still perform as intended.
"SBAUER" wrote:
> I know this can be done using a bat file, but am having issues finding any
> documentation.
> I need to connect to a mapped drive and move trans log backups from on
> server to another server so they can be applied.
> Any help would be greatly appreciated.
> Thanks in advance
> Susan
>|||Thanks Edgardo,
However, my knowledge of VB scripting is very limited.
I'm trying to map a drive and just copy the files over using bat.
I'm sure the way you suggested is the best, but I'm under a time crunch and
don't have time for a learning curve.
"Edgardo Valdez, MCSD, MCDBA" wrote:
> I recommend using VBScript and the Windoes Scripting Host.
> here is some documentation:
> [url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/
url]
> It will allow you to create more robust scripts with error handling and
> logging capabilities. Here are some examples:
> [url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[
/url]
> Search for the Scripting.FileSystemObject to get code samples.
> I used it in the past with very good results. In fact, I have production
> systems that depend on scripts I wrote and they still perform as intended.
> "SBAUER" wrote:
>|||In that case, you can use xcopy
>xcopy /?
Copies files and directory trees.
XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
[/C] [/I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T] [/U]
[/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z]
[/EXCLUDE:file1[+file2][+file3]...]
source Specifies the file(s) to copy.
destination Specifies the location and/or name of new files.
/A Copies only files with the archive attribute set,
doesn't change the attribute.
/M Copies only files with the archive attribute set,
turns off the archive attribute.
/D:m-d-y Copies files changed on or after the specified date.
If no date is given, copies only those files whose
source time is newer than the destination time.
/EXCLUDE:file1[+file2][+file3]...
Specifies a list of files containing strings. Each string
should be in a separate line in the files. When any of the
strings match any part of the absolute path of the file to be
copied, that file will be excluded from being copied. For
example, specifying a string like \obj\ or .obj will exclude
all files underneath the directory obj or all files with the
.obj extension respectively.
/P Prompts you before creating each destination file.
/S Copies directories and subdirectories except empty ones.
/E Copies directories and subdirectories, including empty ones.
Same as /S /E. May be used to modify /T.
/V Verifies each new file.
/W Prompts you to press a key before copying.
/C Continues copying even if errors occur.
/I If destination does not exist and copying more than one file,
assumes that destination must be a directory.
/Q Does not display file names while copying.
/F Displays full source and destination file names while copying.
/L Displays files that would be copied.
/G Allows the copying of encrypted files to destination that does
not support encryption.
/H Copies hidden and system files also.
/R Overwrites read-only files.
/T Creates directory structure, but does not copy files. Does not
include empty directories or subdirectories. /T /E includes
empty directories and subdirectories.
/U Copies only files that already exist in destination.
/K Copies attributes. Normal Xcopy will reset read-only
attributes.
/N Copies using the generated short names.
/O Copies file ownership and ACL information.
/X Copies file audit settings (implies /O).
/Y Suppresses prompting to confirm you want to overwrite an
existing destination file.
/-Y Causes prompting to confirm you want to overwrite an
existing destination file.
/Z Copies networked files in restartable mode.
The switch /Y may be preset in the COPYCMD environment variable.
This may be overridden with /-Y on the command line.
Example:
C:>xcopy E:\SQLData\*.trn \\remoteserver\C$\SQLBackups
"SBAUER" wrote:
> Thanks Edgardo,
> However, my knowledge of VB scripting is very limited.
> I'm trying to map a drive and just copy the files over using bat.
> I'm sure the way you suggested is the best, but I'm under a time crunch an
d
> don't have time for a learning curve.
>
> "Edgardo Valdez, MCSD, MCDBA" wrote:
>sql
documentation.
I need to connect to a mapped drive and move trans log backups from on
server to another server so they can be applied.
Any help would be greatly appreciated.
Thanks in advance
SusanI recommend using VBScript and the Windoes Scripting Host.
here is some documentation:
[url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/ur
l]
It will allow you to create more robust scripts with error handling and
logging capabilities. Here are some examples:
[url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[/u
rl]
Search for the Scripting.FileSystemObject to get code samples.
I used it in the past with very good results. In fact, I have production
systems that depend on scripts I wrote and they still perform as intended.
"SBAUER" wrote:
> I know this can be done using a bat file, but am having issues finding any
> documentation.
> I need to connect to a mapped drive and move trans log backups from on
> server to another server so they can be applied.
> Any help would be greatly appreciated.
> Thanks in advance
> Susan
>|||Thanks Edgardo,
However, my knowledge of VB scripting is very limited.
I'm trying to map a drive and just copy the files over using bat.
I'm sure the way you suggested is the best, but I'm under a time crunch and
don't have time for a learning curve.
"Edgardo Valdez, MCSD, MCDBA" wrote:
> I recommend using VBScript and the Windoes Scripting Host.
> here is some documentation:
> [url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/
url]
> It will allow you to create more robust scripts with error handling and
> logging capabilities. Here are some examples:
> [url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[
/url]
> Search for the Scripting.FileSystemObject to get code samples.
> I used it in the past with very good results. In fact, I have production
> systems that depend on scripts I wrote and they still perform as intended.
> "SBAUER" wrote:
>|||In that case, you can use xcopy
>xcopy /?
Copies files and directory trees.
XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
[/C] [/I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T] [/U]
[/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z]
[/EXCLUDE:file1[+file2][+file3]...]
source Specifies the file(s) to copy.
destination Specifies the location and/or name of new files.
/A Copies only files with the archive attribute set,
doesn't change the attribute.
/M Copies only files with the archive attribute set,
turns off the archive attribute.
/D:m-d-y Copies files changed on or after the specified date.
If no date is given, copies only those files whose
source time is newer than the destination time.
/EXCLUDE:file1[+file2][+file3]...
Specifies a list of files containing strings. Each string
should be in a separate line in the files. When any of the
strings match any part of the absolute path of the file to be
copied, that file will be excluded from being copied. For
example, specifying a string like \obj\ or .obj will exclude
all files underneath the directory obj or all files with the
.obj extension respectively.
/P Prompts you before creating each destination file.
/S Copies directories and subdirectories except empty ones.
/E Copies directories and subdirectories, including empty ones.
Same as /S /E. May be used to modify /T.
/V Verifies each new file.
/W Prompts you to press a key before copying.
/C Continues copying even if errors occur.
/I If destination does not exist and copying more than one file,
assumes that destination must be a directory.
/Q Does not display file names while copying.
/F Displays full source and destination file names while copying.
/L Displays files that would be copied.
/G Allows the copying of encrypted files to destination that does
not support encryption.
/H Copies hidden and system files also.
/R Overwrites read-only files.
/T Creates directory structure, but does not copy files. Does not
include empty directories or subdirectories. /T /E includes
empty directories and subdirectories.
/U Copies only files that already exist in destination.
/K Copies attributes. Normal Xcopy will reset read-only
attributes.
/N Copies using the generated short names.
/O Copies file ownership and ACL information.
/X Copies file audit settings (implies /O).
/Y Suppresses prompting to confirm you want to overwrite an
existing destination file.
/-Y Causes prompting to confirm you want to overwrite an
existing destination file.
/Z Copies networked files in restartable mode.
The switch /Y may be preset in the COPYCMD environment variable.
This may be overridden with /-Y on the command line.
Example:
C:>xcopy E:\SQLData\*.trn \\remoteserver\C$\SQLBackups
"SBAUER" wrote:
> Thanks Edgardo,
> However, my knowledge of VB scripting is very limited.
> I'm trying to map a drive and just copy the files over using bat.
> I'm sure the way you suggested is the best, but I'm under a time crunch an
d
> don't have time for a learning curve.
>
> "Edgardo Valdez, MCSD, MCDBA" wrote:
>sql
Subscribe to:
Comments (Atom)