Error Kickmaleerie

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Thursday, June 23, 2011

Sizing tempdb in SQL Server

Posted on 8:30 AM by Unknown
Today I learnt that it is a bad idea to use the default size (8MB) and growth (10%) values for tempdb in a production environment. And you may also want to consider using multiple tempdb files on different disks. The relevant articles are:

Maximizing TempDB performance by correct initial sizing and Optimizing tempdb performance
Read More
Posted in | No comments

Thursday, June 16, 2011

Find SQL Servers on your Network

Posted on 5:30 AM by Unknown
Very useful script.
Read More
Posted in | No comments
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Popular Posts

  • Dell iDRAC6 Virtual Media Detached error
    See the solution to this error here: http://www.it-book.co.uk/771/error-attaching-iso-in-idrac-%E2%80%93-virtual-media-is-detached
  • more getting the SMS message
    Following my recent " getting the message - too late " post about my employer's evident inability to "get" SMS as a ...
  • Find SQL Servers on your Network
    Very useful script.
  • Java Service Wrapper
    Over the past few months I have been using the very excellent eXist XML database available under the GNU LGPL on a project to store and qu...
  • Changes, changes
    Having reached 60 in pretty decent shape I decided to retire and did so on the 29th July. There will be fewer technical issues blogged as I ...
  • ARPs and NIC Teaming
    Background: A NIC Team is known by a single MAC address to clients in the network. This MAC address is only used as the source MAC address...
  • beyond marks on paper
    Ted Nelson's concept of hypertext predates the web, so it was interesting to get a request this morning from an academic colleague to ...
  • been away a while
    Work and my starting an Open University course ( M358 ) have kept me away for a while. But I'm happy to report having stumbled across t...
  • SQL Server 2000 backuphistory quirk
    We came across this recently when we tried to delete a database and found that the server was churning away for hours at > 50% on each CP...
  • an idiot a day helps you ...
    I've spent one of those difficult weeks in which nothing goes according to plan and you also choose (big mistake) to attempt a rational ...

Categories

  • logs
  • sawmill
  • w3c

Blog Archive

  • ▼  2011 (9)
    • ►  October (1)
    • ►  August (2)
    • ►  July (1)
    • ▼  June (2)
      • Sizing tempdb in SQL Server
      • Find SQL Servers on your Network
    • ►  May (2)
    • ►  April (1)
  • ►  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  August (1)
    • ►  June (1)
    • ►  April (1)
    • ►  March (1)
    • ►  January (2)
  • ►  2009 (5)
    • ►  July (1)
    • ►  May (2)
    • ►  April (1)
    • ►  January (1)
  • ►  2008 (5)
    • ►  December (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
    • ►  February (1)
  • ►  2007 (11)
    • ►  November (1)
    • ►  October (1)
    • ►  August (1)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2006 (15)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (2)
    • ►  August (1)
    • ►  July (4)
    • ►  June (1)
    • ►  March (2)
  • ►  2005 (25)
    • ►  October (1)
    • ►  September (2)
    • ►  August (9)
    • ►  July (1)
    • ►  May (1)
    • ►  April (2)
    • ►  March (1)
    • ►  February (3)
    • ►  January (5)
  • ►  2004 (16)
    • ►  December (6)
    • ►  November (10)
Powered by Blogger.

About Me

Unknown
View my complete profile