SQL Server with Mr. Denny:

April, 2011

1

April 28, 2011  2:00 PM

If i have 3Par SAN, is there any specific recommendations, as it does its custom stripping across the drives. or any other specifics related to 3PAR?

Denny Cherry Denny Cherry Profile: Denny Cherry

The biggest recommendation that I have (pretty much the only one since I haven’t worked with a 3PAR in a while) is to ensure that your LUNs are sized correctly so that they are evenly spread out across all the disks in the disk set that you are using. For example, if you have 100 disks in the...

April 25, 2011  2:00 PM

We get many warnings in our SQL error log about I/O requests taking longer than 15 seconds to complete. What do we do in such scenario?

Denny Cherry Denny Cherry Profile: Denny Cherry

There are a few things which you will want to look at.  First make sure that you have enough RAM for the database to use.  Without enough RAM in the SQL Server you’ll begin putting extra load on the disks because the same data is being pulled into the buffer cache from the disk over and...


April 21, 2011  11:00 AM

Is there a best practice to advise a storage admin how to set a SAN up best for SQL Server OLTP & OLAP? or is this entirely company dependent?

Denny Cherry Denny Cherry Profile: Denny Cherry

There are some general best practices such as separate data and log LUNs, separate TempDB from everything else.  For data warehouses make sure that the data is spread over as many disks as possible.  Anything more specific however is very company specific and would require a good understanding of...


April 18, 2011  2:00 PM

For SQL, best practice is to have data on one array, logs on another array and tempdb on another array. how does this work in san world? SAN people don’t really give all these options when assigning storage for database server.

Denny Cherry Denny Cherry Profile: Denny Cherry

Even when using a storage array it is typically best practice to have the data on one LUN, logs on another LUN, and tempdb on another LUN.  Especially if you have the option to putting each LUN on different physical disks.  If you I talked a little more about this a


April 14, 2011  2:00 PM

So you’ve changed the text display settings, and SSMS still won’t show more than 256 characters.

Denny Cherry Denny Cherry Profile: Denny Cherry

By default SQL Server Management Studio will only show you 256 characters per column.  The fix for this is pretty easy.  You click on Tools > Options to being up the options menu.  From there navigate to Query Results > SQL Server > Results To Text.  Change the "Maximum number of...


April 13, 2011  1:19 AM

Some job descriptions just have to be shared

Denny Cherry Denny Cherry Profile: Denny Cherry

So I'm going along doing my work thing, shrinking databases rebooting servers at random, etc. and I get an email some of which I've included below asking if I'd be interested in this job opening.  I've cut out the names, etc. to protect the stupid. Below is the response that I sent...


April 11, 2011  2:00 PM

Join me at “SQL in the City” presented by Red Gate Software

Denny Cherry Denny Cherry Profile: Denny Cherry

The fine folks at Red Gate Software have made the critical mistake of asking me to be a presenter at the Los Angeles "SQL in the City" event at the Skirball Center


April 7, 2011  2:00 PM

Slide decks for Desert Code Camp (#dcc11)

Denny Cherry Denny Cherry Profile: Denny Cherry

I presented three sessions at Desert Code Camp 2011.1, and I had a great time doing so.  In case you wanted to grab a copy of the slide decks, here they are. Getting SQL Service Broker Up...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


April 4, 2011  2:00 PM

Can tempdb data and log put on on RAID 1 one physical disk, or keep it separate physical disk?

Denny Cherry Denny Cherry Profile: Denny Cherry

It really depends on the amount of load that you put on the tempdb database.  Everything which is done within the tempdb database is going to be logged in the transaction log just like any other database so if the tempdb database has a very high IO then it may make sense to put the tempdb log on a...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: