Thanks for reply..

exec sysmail_help_queue_sp @queue_type = 'Mail' ;

state: INACTIVE..

But I have recevied backup email alert and other alerts also...

As per your script email HTML Report not received for last 24 Hrs auto growth details. But executed successfully

Does it means if database autogrowth disabled at database setting?

That backup job run at under owner of 'servername\Administrator'

For the permission issues, where should i check at server side?

SQL Engine and Agent service running under Network service account.

Does Backup folder need to check? but this folder NT...

1. What's normal for this server for those counters?

I am not sure those counter normal values, It might be < 500 seconds for better (soft/hard page read...

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