Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashwin.oca
Starting Member
2 Posts |
 Posted - 2015-04-21 : 05:14:37
|
| Hi All,I have one table which is used in report. Multiple users are concurrently accessing report and because of that CPU uses is reaching around 96 to 97 percent.So we thought of bring the table to in-memory to reduce disk I/O and for faster access.But we are not getting how to cache full table in memory.Please advice.Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2015-04-21 : 05:56:27
|
| I would optimise the query. If you cannot improve it then CPU = 90+% means you don't have enough hardware. I think trying to cache the table is the wrong solution here, but I'd be interested to hear what other people thing. |
 |
|
|
ashwin.oca
Starting Member
2 Posts |
Posted - 2015-04-21 : 06:10:29
|
| Hi Kristen,Thanks for your reply.But we do not have problem with performance here.I am agree with 'we don't have enough hardware'.I just wanted to know that is there is any way to cache the particular table in memory to reduce disk I/O.Thanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2015-04-21 : 09:18:00
|
| Your problem is CPU reaching 96% - that is not the same as a disk I/O bottleneck.If CPU is 96% and users do not report a performance problem I am surprised. Perhaps the CPU activity is for something else - is ONLY SQL running on this server? or also some other services - such as IIS / ASP.NET etc. ? |
|
|
|
|
|
|
Full table cache in SQL Server 2012