|
|
Friday, June 19, 2009
It's not a new SQL trick, but it's new to me. By adding -T1204 to SQL Server's startup parameters, you get a lovely (perhaps not attractive, but informative) spew of information into the error log every time a deadlock occurs. You can then make helpful announcements like "your query failed because it was fighting with the index rebuilder for access to the statistics on this particular column, and the index rebuilder won."
For example, around midnight this morning, we received an email from an app saying that a SQL statement it ran was chosen as the deadlock victim. A few minutes later, the database emailed me the deadlock trace from the error log.
The error log output contains a snippet of the statement that was killed:Input Buf: Language Event: SELECT DISTINCT location.id, location.name, location.lineage FROM location INNER JOIN webuser_role_location_cascaded wrl ON location.id = wrl.idLocation INNER JOIN role_location ON wrl.idRoleLocation = role_location.id INNER
And what it was trying to use:METADATA: database_id = 5 STATS(object_id = 494624805, stats_id = 8)
And what the other contender was doing:SPID: 62 ECID: 0 Statement Type: ALTER INDEX Line #: 10
What does this globbety-gook tell me? Well, the index rebuilder was building an index -- I can see that from the ALTER INDEX -- and the METADATA bit tells me exactly what the two queries were fighting over -- statistic number 8 on object 494624805 in database 5. I happen to know what database 5 is in my system, but if it's one you don't recognize, a quick trip to the sys.databases DMV will tell you:SELECT name FROM sys.databases WHERE database_id = 5
Use the OBJECT_NAME() function in that database to see what table the statistic is on.SELECT OBJECT_NAME(494624805)
Look in the sys.stats DMV to see what statistic number 8 is. SELECT name FROM sys.stats WHERE object_id = 494624805 AND stats_id = 8 Labels: SQL Server - Diagnostics
Permalink  
Thursday, May 7, 2009
 A mod progression of milk chocolate and minty green stripes is accented with silver dichroic glass. This dinner plate is 8.25 inches square. Order a complete set, and don't forget the matching oval serving platter! Maryland artist Karen Wallace cuts each fragment of glass by hand, piecing her plates and vessels together like quilts. In her home studio, she fires them to a full fuse, shapes them on a diamond lap grinder, then fires them again into their final shape. Each takes hours to lovingly cut, piece and grind, and spends a full day in the kiln. Your fused glass serving piece is completely food safe, and hand washing is recommended. Visit Jellybug Artworks for more pictures and a chance to own this item! Labels: Art, Home Wares
Permalink
 Round coins of chocolaty, iridescent bronzite and wavy coins of a milky green gemstone that might be moss agate are hand-wrapped with solid copper. The pendant is a lovely chunk of polished green opal with gorgeous brown veins. If you've never seen bronzite in person, mere photos do not do it justice! It has sparkling depths, much like tigereye, but with a more complex pattern and a different hue. Dainty bronzite earrings on copper french wires complete the set! The necklace is 18 inches long and fastens with a copper S-hook. The earrings are almost 1.5 inches long. Visit Jellybug Artworks for more pictures and a chance to own this item! Labels: Art, Jewelry
Permalink
Monday, May 4, 2009
 Cheese, crackers, pate .. sip a fine wine and serve your appetizers on a complementary tray made from a recycled wine bottle! I heated a 12 inch wine bottle in my kiln to a roasty-toasty 1425 degrees to flatten it into this adorable serving tray, then etched it with roses. It comes with a stainless steel spreader tied with pretty organza ribbon -- perfect for gift-giving! Visit Jellybug Artworks for more pictures and a chance to own this item! Labels: Art
Permalink
 Cheese, crackers, pate .. sip a fine wine and serve your appetizers on a complementary tray made from a recycled wine bottle! I heated a 12 inch wine bottle in my kiln to a roasty-toasty 1425 degrees to flatten it into this adorable serving tray, then etched it with a cascade of blossoms. It comes with a stainless steel spreader tied with pretty organza ribbon -- perfect for gift-giving! Visit Jellybug Artworks for more pictures and a chance to own this item! Labels: Art
Permalink
Wednesday, April 29, 2009
 A mod progression of milk chocolate and minty green stripes is accented with silver dichroic glass. This platter is 12 inches long and 6.5 inches wide. Maryland artist Karen Wallace cuts each fragment of glass by hand, piecing her plates and vessels together like quilts. In her home studio, she fires them to a full fuse, shapes them on a diamond lap grinder, then fires them again into their final shape. Each takes hours to lovingly cut, piece and grind, and spends a full day in the kiln. Your fused glass serving piece is completely food safe, and hand washing is recommended. Visit Jellybug Artworks for more pictures and a chance to own this item! Labels: Art, Home Wares
Permalink
 This delightful dish features a thick merlot border framing a geometric march of coppery dichroic accents and sparkling wiggles. It is 8 inches square and curves gently up from a flat center. Maryland artist Karen Wallace cuts each fragment of glass by hand, piecing her plates and vessels together like quilts. In her home studio, she fires them to a full fuse, shapes them on a diamond lap grinder, then fires them again into their final shape. Each takes hours to lovingly cut, piece and grind, and spends a full day in the kiln. Your fused glass serving piece is completely food safe, and hand washing is recommended. Visit Jellybug Artworks for more pictures and a chance to own this item! Labels: Art, Home Wares
Permalink
Monday, March 30, 2009
 Tiny red rosebuds on shiny, ridged saucers are perfect for spring! Sterling earwires, 0.75 inches in diameter. Very lightweight. Visit Jellybug Artworks for more pictures and a chance to own this item! Labels: Art, Jewelry
Permalink
Monday, March 23, 2009
 Translucent green, swirly glittering spring green, and yellow topped with a dab of millefiori. This pendant is 1.25 inches wide and 1 inch tall. Visit Jellybug Artworks for more pictures and a chance to own this item! Labels: Art, Jewelry
Permalink
Friday, March 20, 2009
 Are you half-woman, half-goddess? Seven layers of glass have been fused, sawed, sandblasted and fire-polished for shimmering depths and a gorgeous, glossy finish. This pendant is 2.25 inches tall and comes on an 18-inch silver-plated snake chain. Visit Jellybug Artworks for more pictures and a chance to own this item! Labels: Art, Jewelry
Permalink
|
|
