1 Kicks

Very strange Service Broker and TempDB problem (dbalink.wordpress.com)

submitted by MarlonrMarlonr(660) 1 year, 9 months ago

In a nut shell was that the tempdb was taking all the drive space which was allocated to it. On this system, tempdb is sitting on it’s own 50 Gig drive, so SQL can take the entire thing if it needs to. The problem was that sp_spaceused was showing that the entire database was empty, but we were getting out of space errors when running queries which needed to use tempdb.

add a comment | category: | Views: 4

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
MarlonrMarlonr(660)

Comments:

No comments so far

information Login or create an account to comment on this story
View upcoming stories
Submit a story
How else can I help?
Add our feeds to your site

Most Active Users