Forum Replies Created

Viewing 15 posts - 1 through 15 (of 29 total)

  • Reply To: SQL Server Licensing is Simple

    Steve,

    Thanks for the thoughtful reply — I really appreciate it. You make a fair point: in many environments where SA is consistently maintained, VM mobility is limited, and deployments remain...

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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.

  • Reply To: SQL Server Licensing is Simple

    Steve,

    I appreciate the write-up, but I have to push back on the idea that SQL Server licensing is “simple.” That’s a bit like saying jumping out of a plane is...

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: No catalog entry found for partition ID (MSSQL 2005)

    Hello Mr. Randal,

    Finally got a response from premier support below is their final statements.

    Cause

    As per our research this is a known issue only occurs on SQL SERVER 2012 Instances when...

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: No catalog entry found for partition ID (MSSQL 2005)

    Mr. Randal,

    MSFT called back to inform us that we may have a TEMPDB corruption. However, I told them running the consistency checker displays no corruption, therefore, their corruption team will...

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: No catalog entry found for partition ID (MSSQL 2005)

    Hello Mr. Randal,

    Thanks for replying so quickly. We are in the process of opening a case.

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: No catalog entry found for partition ID (MSSQL 2005)

    Hello. I know this is an old post, however, I just experienced this same issue with Microsoft SQL Server 2012 (SP1) - 11.0.3381.0 (X64) Standard Edition. I am still digging...

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: Internal Query Processor Error

    the query is just an single update statement. There are four update triggers on this table, with nested stored procedures, not to mention all the FK references.

    We cannot script...

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: Internal Query Processor Error

    We are running SQL SERVER 2008 R2 STD 10.50.4295 which is the most recent build and we can duplicate this issue on demand. the only workaround we have found is...

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: EMC Legato Ntworker SQL Module

    My pleasure, I am glad I can give back to the SQL Server community. As I mentioned earlier, I will keep this post updated with our progress.

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: EMC Legato Ntworker SQL Module

    Hello,

    EMC mentioned that Networker and it’s SQL module are not going away or being replaced with Avamar. However, we have put together a list of requirments this module must meet....

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: EMC Legato Ntworker SQL Module

    Do you have any documentation that you would consider sharing with your issues/concerns?

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: EMC Legato Ntworker SQL Module

    Thanks again, much appreciated. I pinged our internal storage team, they mentioned that EMC is not deprecating Networker SQL module with Avamar. However, they have a meeting with EMC’s Backup...

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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: EMC Legato Ntworker SQL Module

    Hello,

    Thanks for the information, great to know. Strangely, our internal storage team has not mentioned that EMC is doing away with this module.

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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

    currently looking at getting this information. We have to simulate this in a test environment, which requires us to build a few servers.

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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

    We had to include the SET statements because the trigger was failing without them. We first attempted to place the SET statement outside the procedure which did not work. Therefore,...

    Alfredo Giotti
    Principal Database Administrator / SQL Server Engineer

    Focused 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 15 posts - 1 through 15 (of 29 total)