|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
what are the memory caps for threads running as a CLR stored procedure executed by sql server 2005?what are the memory caps for threads running as a CLR stored procedure
executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored procedure is executed by sql server 2005 then it creates 10 threads and each thread builds a giant array on the stack, is the limits of each array limited by sql server or the os? do these clr stored procedures run inside the sql server address space or does sql server fork a sepperat process for each one? I would take this question to the sqlserver.programming newsgroup.
-- Show quote____________________________________ William (Bill) Vaughn Author, Mentor, Consultant, Dad, Grandpa Microsoft MVP INETA Speaker www.betav.com www.betav.com/blog/billva Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- "DR" <softwareengineer98***@yahoo.com> wrote in message news:e$Zm8irFIHA.3980@TK2MSFTNGP03.phx.gbl... > what are the memory caps for threads running as a CLR stored procedure > executed by sql server 2005? is it limited by OS only or also by sql > servers memory limits? e.g. lets say my clr stored procedure is executed > by sql server 2005 then it creates 10 threads and each thread builds a > giant array on the stack, is the limits of each array limited by sql > server or the os? do these clr stored procedures run inside the sql server > address space or does sql server fork a sepperat process for each one? >  |
|||||||||||||||||||||||
Other interesting topics