Hello,
I would like to make a comment on installing MS SQL Server. I am a developer that also works in support. What I didn't like in this episode is the presenter didn't stress the database files should always go on another disk volume and never on the C drive. I routinely have clients that never pay attention to how their database grows over time until one day it runs out of space. If its also on the C drive then that means the operating system is also under stress now.
Database files should never go on any C drive where the operating system typically resides. They should always be on a separate drive that has some protection against failure like Mirroring for example.
Matt
-
MS SQL Server Episode
-
Matt,
Thank you for watching and I am glad you are enjoying the show so far. I couldn't agree with you more about having the databases stored on a separate drive than the operating system. The reason I didn't mention it in that episode is that I was focused on getting the database engine installed and didn't want to deviate into topics that are covered in later episodes. I have to selectively pick and choose topics for each episode and some require more time than others. Database storage is a big topic, so I saved it for a separate episode. It sounds like you have just started the series so you probably haven't made it to the "Manage and Configure Databases" and the "Optimizing Database Files" episodes where I cover the topic of database storage exhaustively. In those episodes I cover where the databases should be stored, as well as RAID levels and other storage options that can improve performance for the databases and transaction logs.
Thanks again,
Don Pezet
Host, ITProTV -
Don,
Was wondering if in the future you could spend some more time on MS SQL Server Activity Monitor. I recently had to troubleshoot a process that was blocking another process. It took me a while to figure it out. Troubleshooting different database issues on the activity monitor is something any dba sooner or later faces. I realize simulating different issues may not always be easy (depending on the issue), but in general any knowledge of what the activity monitor can do in detail will help any dba.
Thanks,
Matt -
Matt,
I think that is a great suggestion. I used to teach a SQL troubleshooting class back in the day, and it was always a lot of fun. Our schedule is fairly full through January, but I'll see if we can't squeeze in a few SQL shows to add more Activity Monitor / Profiler / Trace content.
Thanks for watching,
Don Pezet
