Viewing 15 posts - 3,766 through 3,780 (of 22,219 total)
PLE all by itself as a measure doesn't tell much. What kind of wait statistics are you experiencing? How fast are the queries? Are you experiencing blocking? I'd be much...
"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
June 7, 2017 at 10:51 am
"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
June 7, 2017 at 7:20 am
"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
June 7, 2017 at 7:17 am
If you want to see what's currently happening, look to the Activity - All Sessions or Activity - Top Sessions reports. They're querying sys.dm_exec_requests (and other Dynamic Management Views) to...
"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
June 7, 2017 at 6:35 am
More and more we're seeing the successful companies move into a DevOps approach. The jobs, DBA & Database Developer, are congealing some. I wouldn't worry too much about the title...
"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
June 7, 2017 at 6:32 am
You should be able to automate this pretty easily through Powershell. You provide a list of servers and then you can query for the list of databases on each server...
"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
June 7, 2017 at 6:19 am
You've never really put together the set of wait statistics that Gail asked for, let alone gathered them one day and then another day and compared between the two (using...
"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
June 6, 2017 at 2:01 pm
I have a table with out any indexes. If I am deleting & Inserting data...
"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
June 6, 2017 at 5:41 am
"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
June 6, 2017 at 4:35 am
Base on that I am...
"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
June 6, 2017 at 4:29 am
krishnabudampati - Monday, June 5, 2017 1:37 PMNo, I am rebuilding indexes before deleting data.
After deleting We are inserting data through SSIS.
You...
"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
June 5, 2017 at 2:57 pm
"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
June 5, 2017 at 2:56 pm
Strong recommendation, if you're upgrading from 2012, don't go to 2014. Go straight to 2016. There are a lot of reasons for this, but I'll give you one big one....
"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
June 5, 2017 at 12:41 pm
"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
June 5, 2017 at 12:32 pm
I have a table, we are deleting data 90% of the...
"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
June 5, 2017 at 12:13 pm
Viewing 15 posts - 3,766 through 3,780 (of 22,219 total)