LUN

Question

Post reply

LUN

mjbkm

Ten Centuries

Points: 1104
More actions
November 28, 2012 at 1:29 pm

#267508

What is a LUN for SQL Databases? :w00t:

Viewing 6 posts - 1 through 5 (of 5 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Nothing.

A LUN is a SAN concept, not a database concept.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

WolfgangE SSCertifiable Points: 6328 More actions · Answer 2

hmmmmm...... what is LUN? what is SAN? And no, I HAVE NOT GOOGLED yet. I know I should have to, but if the terms are used here, why not explain it? 😉

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

weberharter (11/28/2012)
hmmmmm...... what is LUN? what is SAN? And no, I HAVE NOT GOOGLED yet. I know I should have to, but if the terms are used here, why not explain it? 😉

LUN = Logical Unit Number

SAN = Storage Area Network

Honestly the reason they are not explained here is because somebody has already done a better job than I can do off the top of my head.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

weberharter (11/28/2012)
... but if the terms are used here, why not explain it? 😉

Because we assume that people know the basic terminology or, if they don't, will go and look it up.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 5

GilaMonster (11/28/2012)
weberharter (11/28/2012)
... but if the terms are used here, why not explain it? 😉
Because we assume that people know the basic terminology or, if they don't, will go and look it up.

To add to that.... If for no other reason than using a single source of information on the internet has been known to cause people some might grief. It's also a part of the implied job description for anyone that earns their living by working with computers. 😉

--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)