Viewing 15 posts - 10,756 through 10,770 (of 22,224 total)
ChrisM@Work (6/15/2012)
Brandie Tarvin (6/15/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
June 15, 2012 at 6:21 am
crazy4sql (6/15/2012)
If the backup file is of third party, you will get error which if 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 15, 2012 at 5:37 am
There isn't a mechanism that I'm aware to gather that information from MSDB or the backup headers. I've looked for it before and haven't found it. But I could be...
"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 15, 2012 at 5:11 am
Brent's suggestion to use the DMO queries is the closest you can get. Just remember that you're querying against the cache. That means that you can miss information if 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
June 15, 2012 at 4:57 am
Other suggestions are to validate the memory configuration and the disk alignment. I've posted this to #sqlhelp on Twitter.
OK. Stepping back for a minute. What kind of monitoring do 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 15, 2012 at 4:30 am
You may want to look up the max value in the Books Online. They're pretty different between 32 & 64 bit OS.
"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 14, 2012 at 8:38 pm
Hmmm.... Take a look at this article. It might help. They only use two servers. I'm using five, plus a domain controller.
"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 14, 2012 at 11:59 am
Ah well, there you go. Something up with your quorum settings. Makes sense. Change that & you should be good to go.
"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 14, 2012 at 11:10 am
In addition to my book (thanks for the reference) I write about execution plans a lot on my blog, scarydba.com. For lots of even more detailed information, low level stuff,...
"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 14, 2012 at 10:33 am
Just remember that a CTE is nothing but a derived table, a select statement acting as a table. With that in mind, if you think a select statement will allow...
"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 14, 2012 at 10:31 am
GilaMonster (6/14/2012)
A 32 bit OS cannot run a 64-bit SQL Server.
A 64-bit OS can run 32-bit code, but not the other way around.
For memory details, books...
"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 14, 2012 at 8:38 am
Hmmm.... Not sure. Are you getting any errors? What does the cluster look like in the Dashboard with the primary offline? You can look at the health event file? There...
"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 14, 2012 at 8:24 am
ASITKAUSHIK (6/14/2012)
SET STATISTICS IO ON
<YOUR QUERY>
SET STATISTICS IO OFF
just see the if u are getting physical reads 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
June 14, 2012 at 7:57 am
And no, you shouldn't have to share storage in any way between the servers. That's the whole point of this new mechanism for AlwaysOn.
"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 14, 2012 at 7:50 am
If you take a look at the dashboard, are all your replicas synchronized or synchronizing? I've run into issues when the automatic failover was not synchronized. I just ran a...
"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 14, 2012 at 7:49 am
Viewing 15 posts - 10,756 through 10,770 (of 22,224 total)