Viewing 15 posts - 1,621 through 1,635 (of 49,571 total)
Yes, you have 12 cores idle.
The problem is in the number of sockets. For some reason, the VM host is exposing the cores to the VM as 16...
March 29, 2017 at 4:48 am
You're using 4 out of the 16 cores. Probably because that's SQL Server Express, which is limited to 4 cores.
What's the very first (oldest) entry in the error log?
March 29, 2017 at 3:34 am
March 29, 2017 at 1:51 am
Keep in mind that the application name (via App_Name()) can be trivially spoofed, as it's specified by the client.
March 28, 2017 at 4:40 pm
What's the total size of those 65 million rows?
Log file doesn't have to be on a separate drive for In-Memory OLTP. I've had successful tests with...
March 28, 2017 at 9:58 am
The limit is that the data must fit into memory. What's the total size of those 65 million rows?
March 28, 2017 at 9:39 am
alexeliasrp - Tuesday, March 28, 2017 8:27 AMSo, I need to block this type of injection.
What's happening there is that the app...
March 28, 2017 at 9:36 am
At my current company, leaving your laptop unlocked will result in a message being posted to the internal Slack channel, usually saying something like "I don't understand security". In the...
March 28, 2017 at 6:58 am
No, and even if you could, blocking those won't do a thing to prevent SQL Injection. or minimise its impact.
March 28, 2017 at 6:54 am
There's no need to recompile. Procedures' plans are cached in memory only, and so cannot survive a server upgrade (they don't even survive a reboot).
2014 has a new...
March 28, 2017 at 6:45 am
Tune your queries to use less CPU.
https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-1/
Article's a tad out of date these days, use Extended Events not Profiler. Methodology's the same though.
And don't...
March 27, 2017 at 1:09 am
DevOps isn't a job! Any company that thinks 'devops' is a title for someone has rather missed the point of the entire thing.
March 25, 2017 at 4:41 pm
March 24, 2017 at 8:24 am
Firstly 'It's not my problem, it's Bob's', is a terrible way of dealing with anything. I would far rather work with someone who takes responsibility even when it's not their...
March 24, 2017 at 8:10 am
March 24, 2017 at 7:36 am
Viewing 15 posts - 1,621 through 1,635 (of 49,571 total)