Hi, Thanks for sharing script for finding top CPU queries.

select

servername,runtime,max(DBName) as DBName,max(QueryExecuted) as QueryExecuted,(sum(total_worker_time)/sum(execution_count))/@ConvertMiliSeconds as AvgCPUTime

,sum(execution_count) as execution_count,query_hash, max(ObjectName) as ObjectName

into ##FindTopCPUQueries_set2

from ##FindTopCPUQueries_set1

group by query_hash,servername,runtime

order by AvgCPUTime desc

could you...

Thanks for sharing this script..

Email does not coming if database file auto gowth disabled and pre-sized already..

Is it correct?

Thanks Mr. Perrry.

In My case, I have to configure all user database MDF, LDF, NDF file and tempdb will placed to RAID 5 in single logical drive in "E" drive.

Thanks

ananda.

but where is the PLE output like 300 sec..

Thank you Mr. Perry..

As per current configuration in physical server as below

Logical view at HP array configuration tools

1.SAS Array A – 1 Logical drive(s) - RAID 1 (Mirroring)

Total...

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-2 [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.