Sharepoint 2013 bad query performance
Hey there,
we got a new SharePoint 2013 Server, it has has 8 GB RAM and 4 Cores.
It's just a Test so there isn't much data yet, the pages load really quick too.
But if i write a TestApplication and execute Querys their Performance is really bad.
For Example the Execution of "CamlQuery.CreateAllItemsQuery(10)" needs 900 ms.
There are no big Files or anything....
Somebody out there got some experience or at least a clue what to do?
Greetings
Ben
February 27th, 2013 4:56pm
If you put everything on one machine, that is your problem. SharePoint alone needs 16GB of memory. If you put SQL Server on it and any other supporting apps like Visual Studio, then you are not going to have any performance at all.Chris Givens CEO, Architecting Connected Systems
Blog Twitter
Free Windows Admin Tool Kit Click here and download it now
February 27th, 2013 9:51pm
If you put everything on one machine, that is your problem. SharePoint alone needs 16GB of memory. If you put SQL Server on it and any other supporting apps like Visual Studio, then you are not going to have any performance at all.Chris Givens CEO, Architecting Connected Systems
Blog Twitter
February 28th, 2013 5:40am