Viewing 15 posts - 2,326 through 2,340 (of 19,560 total)
TomThomson (8/8/2014)
danrst171 (8/8/2014)
I got it wrong by selecting the second correct answer.
+1
Actually I clicked 2 (query and namespace) and then noticed that clicking the second cancelled the first because there...
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
August 8, 2014 at 7:56 am
MrAkki (8/8/2014)
Hi,I did some testing in our environment and I get about 10% slower performance with TDE enabled. Which is quite okay. 🙂
Thanks.
Best Regards,
Akki
That is sooo good to hear.
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
August 8, 2014 at 7:50 am
MrAkki (8/8/2014)
I don't get it why Microsoft isn't describing the cause of the problem more detailed :ermm:. That would help a lot.
I opened up a call with Microsoft, maybe they...
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
August 8, 2014 at 7:49 am
jasona.work (8/7/2014)
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
August 8, 2014 at 7:34 am
Evil Kraig F (8/7/2014)
rodrigo_fabiam (8/7/2014)
There is not this colums.
It is because this that I want to show this way for the user.
Because they will have to mark...
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
August 7, 2014 at 5:12 pm
I am running about 12 databases on one server totaling 1.5TB - all with TDE enabled. The total cpu cost is about 5%.
The problem with enabling Encryption on all...
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
August 7, 2014 at 3:36 pm
Eric M Russell (8/7/2014)
GPO (8/7/2014)
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
August 7, 2014 at 2:48 pm
GilaMonster (8/7/2014)
Ok, good, I'm not the only one who would think 'blocking' long before thinking 'let me post this impossible situation on the forums'
Oh blocking, yeah that must have been...
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
August 7, 2014 at 2:21 pm
Sure, a pretty good resource is at this link[/url].
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
August 7, 2014 at 1:45 pm
Sean Lange (8/7/2014)
jcrawf02 (8/7/2014)
Sean Lange (8/7/2014)
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.
Speaking of... If you tried running a query against a table (a simple select) and...
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
August 7, 2014 at 1:42 pm
Take the backup and let it complete.
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
August 7, 2014 at 1:41 pm
How big is the backup?
Are you backing up locally or across the network?
Are you compressing the backup?
Are you striping the backup?
All of these things can affect the speed of 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
August 7, 2014 at 1:22 pm
Not sure which application you are referring to, but...
If you were to be using an application such as Dynamix AX from MS, you either create the indexes from within 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
August 7, 2014 at 1:18 pm
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.
Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would...
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
August 7, 2014 at 1:08 pm
Steve Jones - SSC Editor (8/7/2014)
Is the impact more in tempdb or...
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
August 7, 2014 at 12:21 pm
Viewing 15 posts - 2,326 through 2,340 (of 19,560 total)