Could you explain the output result about your script? I got result as below

Average Page Life Expectancy

16:16:32:000

Thanks

ananda

One Final question..

If stop that SQL VSS SQLwrite service, does it help to avoid SQL files backup at windows image backup when running?

Note: currently that service is ruuning.

Thank you Mr.Grant for your valuable reply..

I will asking to server team to execule the SQL file location path at windows image backups.

Ok..I have downloded that H/W books. Chapter 2: The Storage Subsystem. Now i am reading that books..

Thanks Mr. Glenn Berry for free pdf edition.

Built-in windows image backup, they configured Drives "C" and "D" for backups.

also database MDF & LDF files were placed to drive " D" .

whenever starting system image backup also taking...

Version:

OS: Windows 2008 Enterprise Edition with SP1

DB: MS SQL Server 2008 Enterprise edition with SP3..

I searched those issues happened in SQL 2000 and 2005, so can any one could this...

Thank you for reply..

I will convinced to vendor about put on MDF, LDF file on different logical partition in single Physical array controller. Also not getting IO performance for...

Ok.. I will changed to another Separate partition “F” - Tempdb Data and log files.

Pls. suggest. what about other files placement? is it really get performance on different logical...

Verified that all CLR stored procedure coding and they mention as below but access permission is unsafe.

CREATE PROCEDURE [dbo].[CreateCFS]

@uri [nvarchar](255)

WITH EXECUTE AS CALLER

AS

EXTERNAL NAME [CFSserver].[StoredProcedures].[CreateCFS]

GO

Performance vloume task, it has been done at initial setup when database was upgrade to 2008 R2 from 2000.

I resized data file gorwth setting 5 GB then after 5 hrs data files grown upto 642 GB.

Already configured on each table for capture data growth on daily basis with history data.

verifired the history table that Image table row size has increased 1GB on daily basis.

yes. backup file also increased some GB size.

Daily incremental backup. and monthly full backup due to disk free sapce capacity.

This database there is no data retention period also management not accepted to delete old data for identified block listing people.

Data format is storing binary and encrypt format for Photo...

Could you confirm me, Does it support /3GB switch on HyperV serve in Guest OS windows 32 bit?

As per MS Link PAE x86 does not support HyperView server on guest...