Thank you for confirmation,

Case 2. we can restore point in time recovery by using perivious day full backup also apply all second day tlogs backups file even if lost...

Let me explain more details about data recovery in critical situation

As per backup Plan

1. Daily one Full backups at 12:00 AM configured

2. Every 30 minutes Transaction log backup configured

Critical...

Thank you replies.. tested and data was commited in SERIALIZABLE isolation level .

There is one SP and written code like SELECT/INSERT/UPDATE all operation at one single stored procedure, it was...

Ok, Many thanks form experties suggestions.

server side 800 GB freespace available at log file partition, so I am not executed that command let it be gorw that file.

Pls....

Yes.. this is OLTP database, it is very huge tansaction across 8 manufactring sites.

configured sperate Tlog backups ran at every 15 min, each Tlog backup file size is maximum 8...

YES.. Released freespace from HD after modify the initial size at properites.

I have two data files in tempdb, each file setting 500 MB now.

Thanks for replay

Model DB size - 3 MB.

Recovery model - FULL..

Do you know if the apps will handle that?

Yes: I verified those connection by using inputbuffer command, it is showing SQL query related to the user database. But all SPIDs...

Yes, resolved that issues and CPU resource reduced upto 80%..

I am not changed default connection at instance side.

1. capture the query duration time at SQL profiler which are the...

"PreparedSQL" means Ad Hoc query witten in that application side for DML operation, also it is not refer any stored procedure..

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