Viewing 15 posts - 76 through 90 (of 629 total)
The following query will give you a few hours worth of CPU utilization from the DM views
March 29, 2017 at 5:12 am
Another thing I'd add is that's potentially a lot of cores for a VM. In a SQL Server VM environment you really, really want to avoid drastic over provisioning like...
March 29, 2017 at 5:06 am
mike.mcquillan - Friday, March 24, 2017 2:52 AMI 100% agree with Jeff...nobody should deploy their own code....
I've seen that end *very* badly.
At...
March 24, 2017 at 9:11 am
Oh, one other thing to bear in mind. Check their support contract.
In spite of their demand for God Mode, I bet you what you like if they hose your*...
March 22, 2017 at 4:21 am
One option if they absolutely...
March 21, 2017 at 11:47 am
Thom's suggestion makes sense to me too, you could also log the pc being usedSELECT ... SUSER_NAME(), HOST_NAME()
March 21, 2017 at 6:30 am
In reality politics in...
March 7, 2017 at 10:22 am
March 7, 2017 at 9:24 am
March 1, 2017 at 8:50 am
Actually, Gail has a point. I apparently have 34 points from the past 30 days, and I've barely posted anything I can bring to mind
February 10, 2017 at 4:01 am
The following guide for Max memory is as good as any, and better than most.https://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/
however, when you talk about "memory pressure" because SQL Server is using most or...
January 24, 2017 at 3:03 am
If you're after the query plan, why not pull it out of cache?
January 18, 2017 at 4:44 am
james.h291183 (1/6/2017)
January 6, 2017 at 5:18 am
SQL Server Developer Edition is now free. You can download that locally.
http://www.microsoft.com/en-us/sql-server/sql-server-editions-developers
January 6, 2017 at 4:02 am
Viewing 15 posts - 76 through 90 (of 629 total)