Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TomSark
  • Content: Threads
  • Order by date
  1. TomSark

    ASP->COM->OLAP

    Hi, SQL 2000, SP2, etc. We are issuing MDX queries via a COM+ object in an ASP application using ADO (not ADOMD). We are noticing major CPU spikes when the component issues MDX queries to the cube. Analysis services reports that queries aren't consuming any time. NICs are OK. We are the only...
  2. TomSark

    Getting rid of Eager Spool

    Hi All, Does anyone know how to get rid of an Eager spool in a query plan? I've got an INSERT SELECT and SQL Server has determined to spool the clustered index on the inserted table to tempdb (using the eager spool step). This is slowing the query way down. I don't want to drop the index...
  3. TomSark

    FSO FileExists Issue in ASP?

    Hi, What's wrong with this code? The FileExists method returns false, yet the file does exist and this works in a VB program running on the same server, but the asp page does not. Permissions are OK... Thanks in advance, I've left out the rest of the VB Script code... Dim fso Dim myvar...
  4. TomSark

    Getting Process IDs

    Does anyone know how to obtain a process id for a process running on an NT Server? For a given process name, I want to obtain the associated process ID, such as that which you would find when you list running processes in Task Manager... Thanks in Advance... Tom
  5. TomSark

    Memory Leak Monitoring

    Hi, I've been monitoring for MTS component memory leaks by using task manager, looking at the associated mtx.exe processes, and examining whether or not there is a steady increase in memory usage from these processes. My question is: is this the best way to do this, or is there a better way to...
  6. TomSark

    Does SetAbort really clean up objects?

    NT4/MTS/VB6 environment I have heard a lot of people recommend that you should explicitly clean up objects that you've created (set them to nothing in VB) instead of relying on SetAbort to completely handle this cleanup. So, my question is why should you do this? Does SetAbort not clean up...
  7. TomSark

    Pulling MTS/NT/SQL Server together

    Using NT 4.0/SP6a. I would like to: (1) See an association between an mtx.exe PID to a component instantiated in MTS. (2) See an association between a component instantiated in MTS to a SQL Server SPID. Any ideas/recommendations? Thanks, Tom
  8. TomSark

    Pulling it all together

    Using NT 4.0/SP6a. I would like to: (1) Associate an mtx.exe PID to a component instantiated in MTS. (2) Associate a component instantiated in MTS to a SQL Server SPID. Any ideas/recommendations? Thanks, Tom

Part and Inventory Search

Back
Top