A DMV a Day – Day 25
The DMV for Day 25 is sys.dm_os_memory_cache_counters, which is described by BOL as:
Returns a snapshot of the health of a...
2010-04-25
1,700 reads
Glenn Berry
A DMV a Day – Day 24
The DMV for Day 24 is sys.dm_exec_requests, which is described by BOL as:
Returns information about each request that is executing...
2010-04-24
971 reads
A DMV a Day – Day 23
The DMV for Day 23 is sys.dm_os_process_memory, which is described by BOL as:
Most memory allocations that are attributed to the...
2010-04-23
2,400 reads
A DMV a Day – Day 22
The DMV for Day 22 is sys.dm_exec_query_memory_grants, which is described by BOL as:
Returns information about the queries that have acquired...
2010-04-22
1,754 reads
Big SQL Server Announcement This Morning at 7:30AM PDT
Microsoft’s Ted Kummert and Tom Casey are holding a public conference call this morning at 7:30AM Pacific time, where:
Microsoft...
2010-04-21
731 reads
A DMV a Day – Day 21
The DMV for Day 21 is sys.dm_os_ring_buffers, which is helpfully NOT described by BOL as:
The following SQL Server Operating System–related...
2010-04-21
2,585 reads
Staying Current with SQL Server Builds
There was some conversation on Twitter about how to get notification when new Cumulative Updates are released for SQL Server...
2010-04-20
975 reads
A DMV a Day – Day 20
The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as:
Returns a row for each query plan that...
2010-04-20
1,094 reads
SQL Server 2005 SP3 Cumulative Update 9 (Build 4294)
Microsoft has released SQL Server 2005 SP3 Cumulative Update 9, which is Build 4294. I count 13 fixes in this...
2010-04-19
1,087 reads
A DMV a Day – Day 19
The DMV for Day 19 is sys.dm_os_wait_stats, which is described by BOL as:
Returns information about all the waits encountered by...
2010-04-19
2,052 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
ALAMAT KONTAK BCA KCP Katamso Telp:08218154393
WA:08218154393 Jl. Brigjen Katamso No.183, Keparakan, Kec. Mergangsan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55121
ALAMAT BCA KCU SUBANG Telp:08218154393
WA:08218154393 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers