|
||||||
|
All database changes go through me. These have been my catch phrases since taking on the lead SQL developer role at my company, on my team. There have many changes that I’ve had to review – many, many changes, most of them are fine, but occasionally I get a [...] The catch phrase around the office these days is “Big Trys and small Trans.” This came about as we were review stored procedure changes and I two suggestions. First, that the entire procedure has a try…catch around it and second that the transaction be as small as possible. Big Try We’ve got standards in place [...] Check Activity Monitor Anything running? SQL Error Log Any errors? If so investigate Resource utilizations DMVs sys.dm_exec_query_stats Look at: Total physical reads, logical reads, number to executions, total time, (divide those two to get average) Performance Monitors Processor Time Batch requests/sec SQL Wait stats This is the fast way to get a count of all the data in the tables in a database… SELECT [TableName] = so.name, [RowCount] = MAX(si.rows)FROM sysobjects so, sysindexes siWHERE so.xtype = ‘U’AND si.id = OBJECT_ID(so.name)GROUP BY so.nameORDER BY 2 DESC Here’s this week’s weekly challenges…. New release went out last Friday, 4/18/08 – lots and lots of SQL servers Two SQL 2005 Clustered 64 bit I spent most of the week in in the “War” room with a consultant [...] We had a report that was using sys.dm_db_index_physical_stats to find partition progress information. It was taking 45 minutes reguardless of the data in the results. We started looking at the data it was reading. The slow down was around two tables with LOB_Data in them. One table had about 14 million [...] |
||||||
|
Copyright © 2012 Lohn Solutions - All Rights Reserved |
||||||
