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 1234»»»

Lazy Writer Expand / Collapse
Author
Message
Posted Thursday, June 09, 2011 9:32 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734
Comments posted to this topic are about the item Lazy Writer






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1123113
Posted Thursday, June 09, 2011 9:33 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:16 PM
Points: 5,101, Visits: 20,201
Nice clear question - thanks

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1123114
Posted Thursday, June 09, 2011 10:19 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582
Good question, thanks.

Mohammed Moinudheen
Post #1123119
Posted Friday, June 10, 2011 3:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,158, Visits: 642
Nice question Steve.
Post #1123188
Posted Friday, June 10, 2011 5:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:11 AM
Points: 1,371, Visits: 454
Nice question...

-----------------
Gobikannan
Post #1123225
Posted Friday, June 10, 2011 6:20 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:48 AM
Points: 3,125, Visits: 4,311
good question - learned something new (and usefull to boot).
thanks, Steve


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1123252
Posted Friday, June 10, 2011 6:21 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:31 AM
Points: 1,157, Visits: 3,077
Wow. I really had to dig for that one.
Pretty confusing stuff. I'd like to know if anyone here utilizes this feature of splitting physical CPUs for the purpose of creating soft-NUMA nodes for multiple lazy writer threads.

So with one processor, do you have 1 NUMA node by default?


______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
Post #1123254
Posted Friday, June 10, 2011 6:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:12 PM
Points: 369, Visits: 165

Nice question! But I have questions.

What is the best architecture in the real world? Soft-NUMA in SMP, NUMA hardware with soft-NUMA or NUMA hardware only? Is it work fine in any SQL Edition (2005/2008 - Standart, Enterprise, Workgroup, Express...)?

Post #1123269
Posted Friday, June 10, 2011 6:48 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:17 PM
Points: 417, Visits: 227
Good question.
Post #1123271
Posted Friday, June 10, 2011 7:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:09 PM
Points: 2,550, Visits: 18,882
Question is missing a response: "ten forum posts"

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #1123284
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse