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 ««12

Performance issue with a single database Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 6:21 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Im assuming and expecting a value of 0 to be most ideal
Post #1545658
Posted Wednesday, February 26, 2014 11:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
GilaMonster,

You're right!

Its the stats update. That fixed it. However Im trying to understand how this works. Would you be able to give some idea? Thanks.
Post #1545703
Posted Thursday, February 27, 2014 1:00 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:26 AM
Points: 40,423, Visits: 36,872
Google SQL Server statistics and do some reading. Far more than I can summarise here.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1545739
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse