InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:03:41 GMT20http://www.sqlservercentral.com/Forums/Topic1394441-1550-1.aspxCheck the throughput of the SAN system as well as configuration of HBA queue depth.See the virtual file stats if there are high IO read and Write stall( sys.dm_virtual_file_stats).Capture IO, Memory and CPU counters Check Memory Related Perfmon Counters SQLServer: Memory Manager\Memory Grants Pending (Consistent higher value than 0-2) SQLServer: Memory Manager\Memory Grants Outstanding (Consistent higher value, Benchmark) SQLServer: Buffer Manager\Buffer Hit Cache Ratio (Higher is better, greater than 90% for usually smooth running system) SQLServer: Buffer Manager\Page Life Expectancy (Consistent lower value than 300 seconds) Memory: Available Mbytes (Information only) Memory: Page Faults/sec (Benchmark only) Memory: Pages/sec (Benchmark only) Checking Disk Related Perfmon Counters Average Disk sec/Read (Consistent higher value than 4-8 millisecond is not good) Average Disk sec/Write (Consistent higher value than 4-8 millisecond is not good) Average Disk Read/Write Queue Length (Consistent higher value than benchmark is not good)Regards,Ramasankar,MCTS,MCITP Sql server 2008.Wed, 12 Dec 2012 00:05:05 GMTsankar276http://www.sqlservercentral.com/Forums/Topic1394441-1550-1.aspxIt's SAN bases disk(mount point)Mon, 10 Dec 2012 08:30:09 GMTAspet Golestanian Namagerdihttp://www.sqlservercentral.com/Forums/Topic1394441-1550-1.aspxlocal disk or NAS\SAN based disk?Mon, 10 Dec 2012 08:28:39 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1394441-1550-1.aspxand I am using disk for backup operation.Mon, 10 Dec 2012 07:53:29 GMTAspet Golestanian Namagerdihttp://www.sqlservercentral.com/Forums/Topic1394441-1550-1.aspxHere is the waittypes:waittime lastwaittype58608032 ASYNC_IO_COMPLETION51 BACKUPIO0 BACKUPBUFFERMon, 10 Dec 2012 07:52:50 GMTAspet Golestanian Namagerdihttp://www.sqlservercentral.com/Forums/Topic1394441-1550-1.aspx[quote][b]Aspet Golestanian Namagerdi (12/9/2012)[/b][hr].It used to take 7-8 hours for the full backup.but now It is running for 21 hours and still it is not completed.How can I check what is the problem?[/quote] Check the whether database have grown in recent past ?Are you using same disk/storage?I/O utlization? but for this you need to have some historical data for thisMon, 10 Dec 2012 03:38:59 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1394441-1550-1.aspxDo you take tape backup? What are the wait types your backup session is hanging on? Check with your backup team to verify the backup throughput (mb/secs).Sun, 09 Dec 2012 23:06:35 GMTSQL Showhttp://www.sqlservercentral.com/Forums/Topic1394441-1550-1.aspxHi every one,We have database(4.6TB) in SQL SERVER 2008 R2.On weekly bases we take full backup from this database.It used to take 7-8 hours for the full backup.but now It is running for 21 hours and still it is not completed.How can I check what is the problem?ThanksSun, 09 Dec 2012 21:29:11 GMTAspet Golestanian Namagerdi