March 23, 2014 at 11:42 am
Hi,
can anyone please tell me what is meant by ssd and how sql uses this. Also can temp db be moved to ssd
March 23, 2014 at 12:01 pm
March 24, 2014 at 1:31 am
atulyan.aries (3/23/2014)
Hi,can anyone please tell me what is meant by ssd and how sql uses this. Also can temp db be moved to ssd
Yes, tempdb can be moved to ssd. But it isn't a silver bullet for solving your problems.
If tempdb is a bottleneck, you should first find out why that is the cause.
And really do some reading up on SSD and their use for server storage.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 24, 2014 at 5:02 am
Solid State Drive.
It's a drive that uses memory like it was a spinning platter hard drive. So, it's just a drive. SQL Server uses it like any other drive. Just faster.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 24, 2014 at 7:13 am
Koen Verbeeck (3/24/2014)
atulyan.aries (3/23/2014)
Hi,can anyone please tell me what is meant by ssd and how sql uses this. Also can temp db be moved to ssd
Yes, tempdb can be moved to ssd. [font="Arial Black"]But it isn't a silver bullet for solving your problems.
If tempdb is a bottleneck, you should first find out why that is the cause.[/font]And really do some reading up on SSD and their use for server storage.
+1000!
--Jeff Moden
Change is inevitable... Change for the better is not.
March 24, 2014 at 8:16 am
thnx all for your help
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply