Forum Replies Created
Viewing 13 posts - 16 through 29 (of 29 total)
-
RE: PAGELATCH Contention
There is heavy insert and update activity being performed against the temporary table, also with an active explicit transaction. however, the background process being blocked is causing the login trigger...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: PAGELATCH Contention
3) have you tried sp_whoisactive to see if you can get details about what each spid is actually doing? awesome freebie from Adam Machanic
Reply: have the procedure. We know what...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: PAGELATCH Contention
Trigger Code:
BEGIN
SET ANSI_PADDING ON
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_WARNINGS ON
DECLARE @LogonTriggerData xml,
@PostTime datetime,
...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: PAGELATCH Contention
If you are referring to Microsoft CAT as the professional, we are considering it. We cannot disable the logon trigger due to audit compliance. What we have done is disabled...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: PAGELATCH Contention
Good Information, I will take a look the connections for this particular application. Thanks again!
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: Disappearing DBCC Errors
Hello Gail and Paul,
I am some more information detail regarding this problem.
--------------------------------------------------------------------------
Recap:
Error message during DBCC CHECKDB:
Msg 2533, Sev 16: Table error: Page (1:717080) allocated to object ID 181575685, index...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: Disappearing DBCC Errors
Hi Gail and Paul,
Just wanted to follow-up. Our internal hardware and storage team’s insists there are no issues with any of the drivers and hardware between the server and the...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: Disappearing DBCC Errors
Hi Gail and Paul,
Thanks for the great feedback.
The IT hardware team finally reviewed the server found that the array controller has outdated drivers, > 5years old. They are going...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: Disappearing DBCC Errors
Hello Gail,
The server environment is listed in my original post above.
The SAN configuration I am trying to obtain. I have inherited this server.
There are no errors in the SQL...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: Disappearing DBCC Errors
In my original post I mentioned that once the nightly maintenance runs whereby issuing a DBCC CHECKDB, prior to backing up the database, the error is generated. Soon after we...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: Disappearing DBCC Errors
I appreciate your response. When rerunning DBCC CHECKDB the output displays no corruption.
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: Try to give me a solution
With help from a friend, here is the answer
select max(case when (c-1)%3 = 0 then c else NULL end)
,max(case when (c-1)%3 = 1 then c else NULL end)
,max(case...
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
-
RE: DTS to Oracle database
I have the same problem. However, where do you apply the APPEND hint when the MSSQL DTS package is handling the data load?
Alfredo Giotti
Principal Database Administrator / SQL Server EngineerFocused on SQL Server architecture, performance, HA/DR, automation, licensing governance, infrastructure analysis, and enterprise database operations. Writing from practical experience in mature environments where database, infrastructure, and governance decisions must hold up under real operational pressure.
Viewing 13 posts - 16 through 29 (of 29 total)