December 12, 2014 at 3:49 am
Hi All,
I have problem , A new SAN was configured and When Tried to run a Backup (SQL2014) on this it took very long time complete. How do i collect more details on this , Moreover i need to prove that this is some configuration issue on SAN ..
How do i collect those information please advice .
Regards
K.Muthus
December 12, 2014 at 4:41 am
Some ideas off the top of my head :-
Track I/O using perfmon.
Track wait stats from SQL perspective.
Run SQLIO to get indications of baseline I/O SQLIO Tutorial here[/url]
From the lack of info its not clear if you have actually done any work on this yet, but you may have already carried out some of this, its a good idea to include what steps you've already taken (if any).
December 13, 2014 at 5:23 am
Most especially get the wait statistics while the backup is running in order to understand exactly what is causing things to slow down. sys.dm_os_waits_stats will show you a cumulative view. Query it before and after the backup runs. You can also set up an extended events session and capture sql_os.wait_info in real time. Be sure to filter that for the session or query that's running the backup. Also in real time you can look to sys.dm_exec_requests, but you'll have to poll that. Better to use extended events.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply