Viewing 15 posts - 1,621 through 1,635 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 29, 2017 at 3:34 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 25, 2017 at 4:41 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 24, 2017 at 8:10 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 24, 2017 at 7:36 am
Viewing 15 posts - 1,621 through 1,635 (of 49,552 total)