troubleshooting Question

Load SQL DB into Memory

Avatar of burny1
burny1Flag for South Africa asked on
Windows Server 2012Databases
5 Comments2 Solutions693 ViewsLast Modified:
Hi There

We have a SQL table with around 150 mil lines. to execute a query takes a very long time. Having a look at the resources, ram sits at 25% and CPU less than 10% while disk is at 100%.

Is there a way to load the entire table into RAM and work directory from there?
I assume this will also shorten the duration it takes to execute a query.

Do you perhaps have a link on a procedure where i can set this it up guide me in the correct direction.

Thanks in advance
ASKER CERTIFIED SOLUTION
ste5an
Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros