Viewing 15 posts - 5,416 through 5,430 (of 22,227 total)
Markus (10/22/2015)
They are suggesting VM Clustering for SQL2014 Ent. Edition AND Always On.... 😀
It may be that they mean the cluster service, which you have to have for Availability Groups....
"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
October 23, 2015 at 5:28 pm
What they're recommending is Azure virtual machines. That's why a cluster for high availability. Actually though, I'm not sure I'd do that. Instead, if you're moving into this space, why...
"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
October 22, 2015 at 8:24 am
This really comes down to opinion and your personal preferences, but I can recommend Redgate SQL Monitor [/url]for taking care of what you describe. It covers all the metrics you've...
"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
October 22, 2015 at 8:20 am
Jeff Moden (10/22/2015)
Grant Fritchey (10/22/2015)
"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
October 22, 2015 at 7:33 am
m.rajesh.uk (10/21/2015)
HiMy Application stored procedure is not running well. so we cleared cache.
Why? You don't know what the problem is, so instead of troubleshooting, looking at wait statistics and sys.dm_exec_requests...
"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
October 22, 2015 at 4:29 am
It has to be in the contract that negotiate with the company. I have three rates, a friend's rate, an at-home rate, and then a travel rate plus expenses. If...
"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
October 22, 2015 at 4:17 am
Sorry. I don't have something like that at my finger tips. I generally keep everything in source control and do all deployments from there. If you do a search online...
"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
October 22, 2015 at 4:03 am
The fact that the current design consists of a giant table doing nothing but inserts and another giant table where you have to do twenty writes to concerns me quite...
"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
October 21, 2015 at 8:44 am
Not really.
I'm confused by "different environments" though. Are we talking about Development, Testing and Production as "different environments"? Or are we saying, I've got one database on five different...
"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
October 21, 2015 at 8:34 am
Sorry to hear what's going on. It sounds really tough.
Personally, I'd first try making changes to my current position. Explain to them where things are off the tracks and why....
"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
October 21, 2015 at 8:29 am
In addition to what Gail talks about, another thing to consider is a layered approach. Depending on just how responsive and thorough you want your DR process to be, it...
"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
October 21, 2015 at 8:22 am
GilaMonster (10/21/2015)
Grant Fritchey (10/21/2015)
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.
There are sessions that we get to attend?...
"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
October 21, 2015 at 7:29 am
If I had to deal with something like this, I'd go to extended events. You can capture events like object_altered, object_created and object_deleted to see what was done within 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
October 21, 2015 at 7:22 am
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.
There are sessions that we get to attend? Huh. News 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
October 21, 2015 at 7:09 am
Assuming I'm reading this correctly, we can see the Student to Subject Relationship through the Semester to Subject table? I find that a little confusing. The Student isn't related 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
October 20, 2015 at 6:22 am
Viewing 15 posts - 5,416 through 5,430 (of 22,227 total)