Where somedatetimefield >= '2015-12-01...

okay, but their isn't a way to track just the TDE cost or is it just straight cpu %?

I presume just cpu % with getting to peak at the tde...

I think this my have gotten lost in the holiday weekend.

Well, that would have been a good thought but we have already turned it on and turned off the old server.

:crying:

Also are their SSIS or some other sort of Stats...

yes, i see that I was wondering about the cpu time message.

That may be true I'm still pretty new to SQL and we migrated from a physical server to a virtual server which I'm sure is impacting performance do to storage...

So, the long and short of it is that TDE did indeed cause increased overhead and the server was not sized correctly to handle the I/O load.

We also had a...

So does one ever run index rebuilds during live hours.

We have users getting actions suspended and so on.

Also when we bumped the Memory as I watch it. It doesn't seem...

/* Conditional indexing script. */

-- Ensure a USE <databasename> statement has been executed first.

USE iDocs

GO

SET NOCOUNT ON

-- =======================================================

-- || Configuration variables:

-- || - 10 is an arbitrary decision point at...

how wise is that and how intensive are we talking about?

it's not i think the TDE caused table/index fragmentation.

which is causing the issue.

can you run a table by table reindex rebuild while in production? as in not off-hours?

I know that this is a month old post but. . . I am also going to be enabling TDE on databases and was wonder what best practices people follow?

i.e...