Trang Duong

I am a data engineer, also working as DBA not by choice. 🤓

[Trang Duong @SQLStylish]

@vulturetrades Join

[Trang Duong @SQLStylish]

Vespa lover

[Trang Duong @SQLStylish]

@lporiginalg I am so confused by this article 😅

[Trang Duong @SQLStylish]

@lporiginalg 😂

[Trang Duong @SQLStylish]

Sugarcane anyone?

[Trang Duong @SQLStylish]

Another day to work #sql #database #girlscancode #ootd

[Trang Duong @SQLStylish]

@SQLTrooper @GavDraper @kevchant That’s why the query on the replica is super slow. I will reconfig the replication tonight to make sure it’ll bring the indexes over. Thanks again for all your help! 🙏🤓

[Trang Duong @SQLStylish]

We have 2 servers. (1) is the SSRS Report Server, (2) hosts all the data. I truncated the log on (2). After that all the reports slow down, some of them timeout and crashed. I can run any the reports from VS locally. Please help, it’s been a week our reports not working #sqlhelp

[Trang Duong @SQLStylish]

@SQLTrooper @GavDraper @kevchant Hi everyone, thank you very much for your help. I compare the execution plans on 2 servers and found out the replica doesn’t bring over all the NC indexes.

[Trang Duong @SQLStylish]

@kevchant @SQLTrooper @GavDraper @kevchant my autogrowth set is 100mb.

[Trang Duong @SQLStylish]

@kevchant @SQLTrooper @GavDraper I’ll look into that now

[Trang Duong @SQLStylish]

@GavDraper @SQLTrooper @kevchant And I tried to recompile 1 proc that use to generate 1 report. @GavDraper I agree with u it’s para sniffing. I also checked the time report rendering, it takes a lot of cpu to render just 1 report.

[Trang Duong @SQLStylish]

@GavDraper @SQLTrooper @kevchant Our system admin has a snapshot of our report server and the plan was to rollback to 3 weeks ago when everything was running fast. It didn’t get any faster after the switch, so he changed it back to where we were.

[Trang Duong @SQLStylish]

@GavDraper @SQLTrooper @kevchant Yes!

[Trang Duong @SQLStylish]

@SQLTrooper @GavDraper @kevchant Currently I am not sure what to do next, still researching and reading here and there. #sqlhelp

[Trang Duong @SQLStylish]

@GavDraper @SQLTrooper @kevchant Hi I ran the query without recompile took 37 sec to complete. With option recompile it took 34 sec. What does it tell you?

[Trang Duong @SQLStylish]

@GavDraper @SQLTrooper @kevchant Thank you! My thought exactly just bad timing. The reports just started to slow down right after I truncated the log and rebuilt the replication. Will do it now and let you know. 😖

[Trang Duong @SQLStylish]

@SQLTrooper @kevchant @GavDraper Thank you. I have a dumb question if there’s a possibility that’s because of me truncating the transaction log on the db (on server 2) that the report server (server 1) query to cause the slowness on the reports?

[Trang Duong @SQLStylish]

@kevchant @GavDraper I have ran the query on SSMS where the data is and it ran fine.

[Trang Duong @SQLStylish]

@GavDraper Thanks Gavin, I’ll take a look tomorrow. I’m falling asleep. I’ll keep you updated. Much appreciate your help! 😁🙏