Articles on CLR Scalability?

Question

Articles on CLR Scalability?

David.Poole

SSC Guru

Points: 76191
More actions
February 26, 2009 at 10:40 am

#200704

Does anyone have any links to some good articles on CLR scalability?
I believe Adam Machanic wrote such a piece but I have been unable to find it.
I am trying to find out how the CLR behaves when database servers are used for high traffic web sites.
I am mainly looking at simple table value functions and scalar functions.
LinkedIn Profile

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

I emailed Adam with your questions and the link to this post. If he reply's to me directly, I will post his response here for you.

David.Poole SSC Guru Points: 76191 More actions · Answer 2

David.Poole

SSC Guru

Points: 76191

February 27, 2009 at 4:20 am

#951052

Thanks Jonathan, much appreciated.

LinkedIn Profile

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 3

Here's one, straight from the horse's mouth....

http://technet.microsoft.com/en-us/library/ms131075.aspx

The part that they left out is that there's normally a way to do the same thing in more than 95% of the case in T-SQL with performance that will beat the CLR. The exceptions that I know of are RegEx Replace and File Handling... but even then, the CLR doesn't crush the T-SQL solutions.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)