SSC Clinic: Finding the rogue query
When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.
2012-09-13
5,995 reads
Memory
The Real World: Implementing AWE
Describes the gains experienced in my environment by implementing AWE.
2012-05-16
8,005 reads
Calculate the values for MAX Memory for SQL Server
Use this script to calculate MAX memory setting on a dedicated SQL server.
2012-01-27 (first published: 2011-12-14)
3,258 reads
SQL Server Memory Management Explained
Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.
2011-09-20
14,262 reads
SQL Server Memory Configuration, Determining MemToLeave Settings
Tweaking SQL Server memory settings to provide support for managed code.
2009-07-06
11,868 reads
You thought SQL Server ate up memory…
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially. If your data set is growing over time you will end up using any memory that is not consumed today.
2009-04-15
3,029 reads
RE: DTS error executing from Stored Procedure
are you using an odbc connection, is that connection present on the server?
2005-05-24
server 2000 or 2003
Hi i need an inexpensive way to get a server OS with SQL Server.Looked at the OS bundles but ???
2005-05-06
RE: calculation
I believe you missed the point I was trying to make. Your (num.number + 1)/@NumPayments) statement only fires when @NumPayment = 12. That's why I suggested posting the code; so we could look at the unambiguous code rather than a statement of content. Since I only inferred from your first statement that the code contained an IF […]
2005-04-28
Audit table to hold rowcount of several views
Guys:I have a table that will hold rowcounts as count(*) of several views.The table has PK and Timestamp as well as count value for each view.I need to watch the rate of rowcount increase as the month progresses in Month to Date Views.I do an insert of the rowcount value for the first value [works fine, with […]
2005-04-08
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers