As I was working on a database yesterday I came across a curious sight, multiple columns defined as numeric(7,0), numeric(9,0), and so on. It seemed like someone was trying to provide the database with the most specific definition possible for a number of different pieces of data. Having never run into this particular practice, I immediately started searching for a reason. Was it smaller? faster? better?
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
There are hundreds if not thousands of T-SQL Scripts, Powershell Cmdlets, .NET programs and even old vbscript scripts and on out there to monitor SQL Server and Operating System level performance. I’ve written hundreds of them myself over the years. All of that time and work absolutely paid off. I know a lot about monitoring, going after the right information when something specific is wrong. It also gives me a bag of tricks that mostly causes laptops to run out of disk space often. Disk is cheap though, these days.
In the last post, “Baseline, Performance Reporting and being a proactive DBA” touched on baselines and using them to set thresholds for actively monitoring performance problems on SQL Server. From that post we briefly discussed that every database server is unique. That even being true when the databases we attach to SQL Server are packaged installations from third party applications (like SAP, Dynamics etc…). I received feedback from my good friend Aaron Lowe (Twitter | Blog) on this topic and a very good conversation on how we create these baselines. Aaron had a great point regarding there not being much out there on exactly how to do this so I thought I’d write up a follow-up to the article and some points you can use to create your own baselines.
As database professionals, our intent is to be as proactive as possible when it comes to delivering data with security, stability and speed in mind. Being proactive means active monitoring, reporting performance variations and most important, baseline capture. Adding to these three objectives, we can add Performance Notes to also provide key points of long […]
Defaults hurt. They take a 3 inch splinter and try to bury it as far up and under your nail as far as they possibly can. Every database server has a task. A mission if you will. That mission is to serve the data and secure the data. Some need 32GB of RAM; some need 3GB of RAM. This one might need 32 spindles on RAID 3 billion.
You see this kind of question all the time in newsgroups/forums, someone wants to return all the rows if nothing is passed in or just the rows that match the variable when something is passed in. Usually someone will reply with a suggestion to do someth…
Lee Everest created a post named MongoDB vs. SQL Server – INSERT comparison where he compared inserting 50001 rows with MongoDB vs. SQL Server. So he claims that MongoDB inserts 50001 rows in 30 seconds while the SQL Server one takes 1.5 minutes. Okay so I looked at this SQL Script and can make 2 […]
Index DMV/DMF goodness! SQL Server 2005 and up has given us the ability to truly be more efficient in gathering information in which we can be more proactive. With everything these objects give us, a price has to be paid. We will discuss that price but first, we’ll go over a few major features that DMV/DMF has provided to us in regards to indexes to help us in our daily tasks.
In order to figure out if you need more memory for a SQL Server you can start by taking a look at Buffer cache hit ratio and Page life expectancy. Buffer cache hit ratio Here is what Books On Line has to say about Buffer cache hit ratio Buffer cache hit ratio Percentage of pages […]
So I just got a brand new shiny QuadCore PC with 6GB of RAM and Vista on it. I decided to setup ReadyBoost since I have a couple of USB dongles laying around. How does ReadyBoost work? Here is what Wikipedia has to say Using ReadyBoost-capable flash memory (NAND memory devices) for caching allows Windows […]