Viewing 15 posts - 10,996 through 11,010 (of 22,224 total)
There are a bunch of ways ot tell what version of SQL Server you have. Microsoft has them documented here. The best is to query directly:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY...
"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 26, 2012 at 10:22 am
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
"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 26, 2012 at 7:45 am
Thomas Stringer (4/26/2012)
Great information and summary, Grant.
Thanks. I've had a little practice laying out that information though, so it's not that big an accomplishment.
"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 26, 2012 at 7:44 am
I found a bug in AlwaysOn. Anyone want to vote on 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
April 26, 2012 at 7:43 am
Looks like it's a bug. I just submitted this on Connect if you want to go vote for 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
April 26, 2012 at 7:39 am
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
"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 26, 2012 at 6:59 am
Looks like everything is retyped for us to hide things, but based on what's typed, it's saying the VALUE is the problem, not the column name.
"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 26, 2012 at 6:58 am
I just did a series of tests with my AlwaysOn test environment. I failed over multiple times on an existing database, AdventureWorks2008R2. I didn't see the reseed occur. I tried...
"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 26, 2012 at 6:52 am
I was going to say the same thing. Check the data on the other server. That must be where the duplicate is.
"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 26, 2012 at 5:32 am
Usually that would be an indication of a full drive. There must be an error or a message or something.
"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 26, 2012 at 5:29 am
From what you described, it doesn't sound like you need a plan guid. Just add the query hint directly to the query.
Creating plan guides, every single bit of white space,...
"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 26, 2012 at 4:57 am
You could use merge replication to ensure that the same data goes to all three servers, regardless of which one inputs the data. But that requires changes to your table...
"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 26, 2012 at 4:52 am
If you're working in 2008 or better in SQL Server, I strongly recommend you use Extended Events. That's the least intrusive way to gather metrics. There's no GUI available unless...
"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 26, 2012 at 4:48 am
You're getting deadlocks from your backup software? That's really not good. Contact the vendor. If they don't have an immediate fix, find another vendor. I have a suggestion on...
"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 26, 2012 at 4:27 am
Monitoring the server generally means gathering different kinds of performance metrics. SQL Server comes with four tools that allow you to set this up on your own, Performance Monitor, Server-Side...
"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 26, 2012 at 4:26 am
Viewing 15 posts - 10,996 through 11,010 (of 22,224 total)