Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Collection ( MDW ) - tempdb Expand / Collapse
Author
Message
Posted Sunday, March 30, 2014 8:25 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 3:17 AM
Points: 163, Visits: 483
hello,

do you have experience with this? It is possible that Data Collection can cause massive increasing MB/sec to tempdb ? I cannot find connection with tempdb and I set cash file, but on same disk.

Or it can be something different? Last two weeks what I checked was Read/Write MB/s to tempdb increasing progressively.
One time it was about 20MB/sec

after it was reseting and again 1MB/sec..

Does you have experience with this?

What I checked , External company which install SQL Server made one file for tempdb, next week or during breaktime(it will be possible), I would like make 8files next weekend work.


Now I saw that TempDB mdf was still increased, but using was just 8-10%
Post #1556278
Posted Sunday, March 30, 2014 9:02 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 3:17 AM
Points: 163, Visits: 483
i turned off Query statistics collect and the MB/s to tempdb was rapidly decreased

Post #1556281
Posted Sunday, March 30, 2014 9:08 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 3:17 AM
Points: 163, Visits: 483
If I understand this is because it use almost same queries like Activity monitor every 10sec, and inside these queries are #table , yes?
Post #1556283
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse