meta user
network profile
| bio | website | profdata.com |
|---|---|---|
| location | Temple, TX | |
| age | 41 | |
| visits | member for | 1 year, 7 months |
| seen | 22 hours ago | |
| stats | profile views | 20 |
I've been programming for about 20 years now (eek!). My first job was in COBOL, but mainframes and I do not mix. I coded several years in Java back in the JDK 1.0.2 days. Did some C++ and COM. Worked on Java + WFC from Microsoft. Been writing C# code for 6 years.
Married with two kids. Kids do not compute. Wife is wonderful, understanding, and sympathetic, but she=g=d=+++----CARRIER LOST
|
May 10 |
revised |
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR added results of MS support call |
|
May 10 |
comment |
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR The SQL Server engineer agreed it was probably the IDENTITY column. We took it off of the already wide clustered index and removed the column entirely. It was not necessary. Afterwards, these LATCH_EX waits went away. We could not duplicate the waits on SQL 2008 R2. The issue happened only on SQL Server 2012. |
|
May 10 |
accepted | LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR |
|
Apr 23 |
revised |
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR noted MS case opened |
|
Apr 23 |
comment |
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR Thank you for the response. I agree if that's the issue, using some manufactured key (or no key at all) might fix it. We've opened a case with Microsoft regarding this issue. I'll post the result here and accept your answer if they agree that is the problem. |
|
Apr 19 |
comment |
LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR At the step it is waiting, it is copying a single store's inventory records into the permanent table without transformation. We could operate inside the permanent table the whole time, but I think the programmer opted to use a #Temporary table as the holding area to prevent frequent updates to the data from converting into PAGE locks. |
|
Apr 19 |
asked | LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR |
|
Apr 17 |
awarded | Notable Question |
|
Mar 20 |
awarded | Self-Learner |
|
Mar 8 |
comment |
Will Startup Procs Run Again After Database Recovery? The customer's database recovery actually jumped from LOW% to 100%, and then SQL Server ran the startup procs as expected. I expect the startup procs would have been run again, but I don't have proof. |
|
Mar 8 |
asked | Will Startup Procs Run Again After Database Recovery? |
|
Feb 18 |
comment |
Detecting SQL Server Utilization with a query @StrayCatDBA Is the CPU usage in the ring buffer a discrete measurement (i.e. right now) or an average since the last measurement (i.e. in the last X seconds)? |
|
Feb 13 |
revised |
Deadlocks From Locks on Same Temporary Tables In Different Processes added 187 characters in body |
|
Feb 13 |
revised |
Deadlocks From Locks on Same Temporary Tables In Different Processes added 150 characters in body |
|
Feb 12 |
revised |
How do you manage SQL jobs that belong to a database? added 118 characters in body |
|
Feb 12 |
comment |
Detecting SQL Server Utilization with a query +1 For mentioning the system health session |
|
Feb 12 |
answered | How do you manage SQL jobs that belong to a database? |
|
Feb 12 |
revised |
Detecting SQL Server Utilization with a query added 207 characters in body |
|
Feb 12 |
accepted | Synchronize Queries Retrieving Sessions And Locks From DMVs |
|
Feb 12 |
answered | Detecting SQL Server Utilization with a query |
