Viewing 15 posts - 4,891 through 4,905 (of 22,219 total)
I have an example on the blog here [/url]that pulls out Missing Index information.
"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
April 1, 2016 at 6:37 am
Again, no. There's not enough information to make intelligent suggestions. You've listed an OS and version, SQL Server version, and the fact that you're running on a VM, but not...
"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
April 1, 2016 at 6:21 am
For it to be that precise, something is running a process I'd guess. Do you have monitoring in place to capture query executions? If not, try trace (since you're still...
"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
March 31, 2016 at 7:23 am
Beatrix Kiddo (3/31/2016)
Yes. Spend some time reading Perry Whittle's Stairway to AlwaysOn.
This
"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
March 31, 2016 at 4:33 am
Excellent. Glad things worked out.
"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
March 30, 2016 at 6:10 pm
TomThomson (3/30/2016)
Grant Fritchey (3/30/2016)
TomThomson (3/30/2016)
"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
March 30, 2016 at 3:16 pm
First, I'd determine if there were stored procedures that could, conceivably, be calling that table. If there are any, it complicates this slightly.
The events you want are sql_batch_complete and rpc_complete...
"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
March 30, 2016 at 11:58 am
I've been doing it for years. I backed up locally (because it's faster) and the used powershell to copy the files out to Azure blob storage. Done.
You can get fancy,...
"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
March 30, 2016 at 11:53 am
You can.
I wouldn't necessarily base it on PLE though. What kind of wait statistics are you seeing?
"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
March 30, 2016 at 11:42 am
Another way would be to launch SSMS (or whatever you're using to run you queries) using "Run As" inside of Windows. Right click on the icon.
"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
March 30, 2016 at 11:41 am
TomThomson (3/30/2016)
"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
March 30, 2016 at 11:37 am
the version numbers are strictly internal management mechanisms for SQL Server. They're not something you need to worry about under normal conditions. Why are you so focused on this level...
"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
March 30, 2016 at 11:36 am
Yep. That's it. The WSFC has the management interface that AG needs to do what it does.
"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
March 30, 2016 at 11:18 am
szejiekoh (3/30/2016)
Grant Fritchey (3/30/2016)
"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
March 30, 2016 at 10:27 am
dajonx (3/30/2016)
"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
March 30, 2016 at 8:49 am
Viewing 15 posts - 4,891 through 4,905 (of 22,219 total)