Steve Jones - SSC Editor (8/7/2014)
Not to hijack too much, but is the data highly distributed towards numbers or characters? Large fields of text?Is the impact more in tempdb or the user db?
yes 😉
they have large text fields. They have guids as the clustering key - big impact on it.
Tempdb is less of an issue than the fragmentation of the indexes.
I think the bigger issue is really that the fragmentation becomes a lot more noticeable because of the little bit of a hit that is caused by TDE.
Nothing a lot of code tweaking and perf tuning can't really handle.
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