Viewing 15 posts - 3,106 through 3,120 (of 49,552 total)
In that case, it should be fine. Start with all SQL 2014 replicas in an AG and upgrade them one by one.
https://msdn.microsoft.com/en-us/library/dn178483.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2016 at 6:44 am
No (with caveat).
The root reason here is that databases cannot be downgraded, nor can log structures. So while it should be possible to have a primary replica on 2014 and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2016 at 6:36 am
Unless you had some custom monitoring, you're not going to get that.
You can query the plan cache (sys,dm_exec_query_stats cross apply sys.dm_exec_sql_text) to get the text and last execution time of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2016 at 6:26 am
I'd recommend extended events on 2012. Add in the QueryHash column and the aggregation is trivial to do in T-SQL, no need for string comparisons for ad-hoc queries any longer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2016 at 1:06 pm
Identify the queries using the most CPU and tune them. This may not be the most expensive individual queries, probably isn't. The query that runs once an hour for 5...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2016 at 10:53 am
I don't delete one row at a time, but if there's a where clause that defines which rows to delete, it's pretty easy to delete batches in a while loop,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2016 at 9:27 am
Other than high values of something that doesn't mean too much alone, is there a problem here?
Are the inserts getting adversely affected by the deletes? Is the delete running too...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2016 at 9:05 am
It's unlikely to save any time, CTEs aren't inherently slow.
I took the nolock hints out, as I suspect you probably don't want incorrect results every now and again. If you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2016 at 8:22 am
The log backup will be the same size, or even larger, as any extents affected by the minimally logged operation are copied into the transaction log backup. The advantage is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2016 at 3:16 am
Sean Lange (5/4/2016)
WayneS (5/4/2016)
Anyone else having trouble receiving the SSC newsletters? I just received Saturday's "Database Weekly", and I haven't received any of the daily ones this week.
Yeah they seem...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2016 at 10:11 am
Replace 'y' with the number of characters to trim off the end
DECLARE @str VARCHAR(100) = 'adventure-works\peter0'
select substring(@str,17,LEN(@str)-(17-1) - y)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2016 at 7:24 am
Any good bookshops in London? (for next time I visit)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2016 at 7:11 am
Brandie Tarvin (5/4/2016)
GilaMonster (5/4/2016)
jasona.work (5/4/2016)
GilaMonster (5/3/2016)
jasona.work (5/3/2016)
GilaMonster (5/3/2016)
jasona.work (5/3/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2016 at 7:09 am
aaron.chapman (5/4/2016)
I guess this is because the Copy Only backup does NOT initialize the log chain.
It should initialise the log chain, copy-only is on a full backup supposed to only...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2016 at 6:56 am
jasona.work (5/4/2016)
GilaMonster (5/3/2016)
jasona.work (5/3/2016)
GilaMonster (5/3/2016)
jasona.work (5/3/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2016 at 5:54 am
Viewing 15 posts - 3,106 through 3,120 (of 49,552 total)