asked on

SQL TempDB Question

Ok so I'm really strapped for funds at the moment, and my SQL server is sluggish. All I have on hand that may help is a Intel 910 PCIe SSD. Since I don't have the resources to put this in any kind of RAID. My question is...say I put my TempDB on the SSD and it fails. What if any data loss would there be in that senario. Obviously I would never put my logs or data files on a non-RAID drive, but I just don't know enough about the TempDB to determine what would happen if the SSD were to fail. If all that happens is the DB goes offline, but there is no risk of data loss, then I could live with that while I re-pointed it to another drive. However if it corrupts a bunch of data and puts me into a restore from backup situation, that wouldn't be worth the risk.

Now I know the correct answer is probably to add another array, but I have what I have and there simply isn't any money right now.

Thoughts!

Guy Hengel [angelIII / a3]

tempdb failure is no issue at all. just restart the sql server instance, and the tempdb is recreated (from "scratch"). just the disk needs to be there and working.

bhieb

ASKER

So what your saying, is that if the SSD fails. Then kick the users out, point the TempDB back to the slower array, and restart the instance. That doesn't seem like too big of a risk so I think I'll give it a shot. Right now my Server level is Standard and only able to see 32GB of memory so even adding some there does nothing since it can't see it. That is why I figured I would get at least some bang for my buck by using this "free" SSD. It was bought for another test, so is basically completely unspoken for, if I could afford another I'd stick them in RAID1 and move my datafiles and tempdb there but hey maybe next quater.

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial