Viewing 15 posts - 1,096 through 1,110 (of 19,560 total)
I like the snapshot method for Enterprise edition.
An alternative would be to detach and reattach during a maintenance window. The caveat here is to ensure a backup is performed first,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 28, 2015 at 12:02 am
I think I have an idea of how you got to where you are with these tlogs and vlfs. I have just been able to repro it with the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 5:09 pm
Jacob Wilkins (7/27/2015)
You just have...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 3:07 pm
Your Loginfo results are a bit wonky.
It shows that the first vlf is 8kb and the second vlf is ~1090mb. This is not normal.
Second piece of wonky is that...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 2:58 pm
dbe003-forum (7/27/2015)
studio is now installed 🙂
Congrats
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 12:48 pm
Revenant (7/27/2015)
Ray K (7/27/2015)
DonlSimpson (7/26/2015)
TomThomson (7/25/2015)
SQLRNNR (7/25/2015)
outre-merultramar
Montreal
Expos
Nationals
GNATS
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 12:47 pm
Jack Corbett (7/27/2015)
Brandie Tarvin (7/27/2015)
SQLRNNR (7/27/2015)
Brandie Tarvin (7/27/2015)
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 12:02 pm
Luis Cazares (7/27/2015)
SQLRNNR (7/27/2015)
One niggle. The looping-set update is not technically RBAR since it is performing groups of set-based operations.
That was exactly the point of this article, to differentiate RBAR...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 10:24 am
One niggle. The looping-set update is not technically RBAR since it is performing groups of set-based operations. Maybe it should be called SBAS. 😀
I have used this method many a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 10:11 am
jasona.work (7/27/2015)
Which, having seen the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 10:05 am
Brandie Tarvin (7/27/2015)
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for bring up the topic, Jason. And hold...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 10:03 am
Toreador (7/27/2015)
SQLRNNR (7/25/2015)
Well, if the view does not exist or is in a different schema, then the third option is correct even though it truncated part of the error. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 27, 2015 at 8:47 am
TomThomson (7/25/2015)
What is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 25, 2015 at 9:59 pm
Are you getting an error during the install?
I have installed it several times separately, so I would expect some sort of error if it is not working for you.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 25, 2015 at 6:12 pm
outre-mer
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 25, 2015 at 9:12 am
Viewing 15 posts - 1,096 through 1,110 (of 19,560 total)