How to change default backup destination to the other folders ?

By default,when I would like to back up any database by SSMS.

default destination on disk will be C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ every time

Although I everytime change it to my backup folder.

Please let me know how to change it.

I believe you can either write a query or create a procedure:

e.g.

CREATE PROCEDURE mybackup

AS BACKUP DATABASE [databasename]TO DISK = N'c:\SQL\Backup\databasename.bak'WITH RETAINDAYS = 1, NOFORMAT, NOINIT,NAME = N'databasename-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GO

How to Capacity Plan for CPU and Memory for a new SQL SERVER Setup

Hi all,

We are going to setup a new server,so for that How to Capacity Plan for CPU and Memory ,Hard Disk for a new SQL SERVER Setup.

Is there any specific criteria for capacity planning ?in which base we should do this part.

Thanks

Kumar

In general...

...if the database is big, buy more RAM.

...if the database is subject to heavy modification, buy fast hard drives.

...if you have a lot of users and/or have a lot of complex queries running, but faster/more/multi-core CPUs.

It's not an exact science.

-Ryan / Kardax

|||

Hi Ryan,

Thanks alot.

Is there any other way to plan so that it's easy for Newsetup Servers.

|||

Hi,

How to plan the Capacity Plan for CPU and Memory for a new SQL SERVER Setup.

How to Capacity Plan for CPU and Memory for a new SQL SERVER Setup

Hi all,

We are going to setup a new server,so for that How to Capacity Plan for CPU and Memory ,Hard Disk for a new SQL SERVER Setup.

Is there any specific criteria for capacity planning ?in which base we should do this part.

Thanks

Kumar

In general...

...if the database is big, buy more RAM.

...if the database is subject to heavy modification, buy fast hard drives.

...if you have a lot of users and/or have a lot of complex queries running, but faster/more/multi-core CPUs.

It's not an exact science.

-Ryan / Kardax

|||

Hi Ryan,

Thanks alot.

Is there any other way to plan so that it's easy for Newsetup Servers.

|||

Hi,

How to plan the Capacity Plan for CPU and Memory for a new SQL SERVER Setup.

How to calculate AVG. Disk Queue Length

Hi All,

we have collected perfmon data for a specific lun. Here is the background of the lun. The lun is Raid10 with 4 physical disks. We have problems interpreting the data. In the perfmon counter screen we have a max of 435 and average of 0.512. Can somebody tell us what is that we are missing? Any help is greatly appreciated.

Thanks,

Venkat.

In theory the 'magic' number for avg. disk queue length is 2 per spindle.

There are however counters which are more interesting like avg. disk sec/read and avg.disk sec/write which should be below 20ms for data disks and below 3ms for log disks.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

thanks for answering. Remember, when you look at the PerfmonCounters, you always have them in units as 1.00 or 100. how do you correlate those units with the actual readings you are seeing?

|||

The value is always in the unit the counter mentions. The graphs can have a different scale and this can be changed through the properties.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

How to calculate AVG. Disk Queue Length

Hi All,

we have collected perfmon data for a specific lun. Here is the background of the lun. The lun is Raid10 with 4 physical disks. We have problems interpreting the data. In the perfmon counter screen we have a max of 435 and average of 0.512. Can somebody tell us what is that we are missing? Any help is greatly appreciated.

Thanks,

Venkat.

In theory the 'magic' number for avg. disk queue length is 2 per spindle.

There are however counters which are more interesting like avg. disk sec/read and avg.disk sec/write which should be below 20ms for data disks and below 3ms for log disks.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

thanks for answering. Remember, when you look at the PerfmonCounters, you always have them in units as 1.00 or 100. how do you correlate those units with the actual readings you are seeing?

|||

The value is always in the unit the counter mentions. The graphs can have a different scale and this can be changed through the properties.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com