Re.restore & table accessed by users.

Hi, Have 2 questions for you folks: 1) We took backup, made some changes on the table for new indexes and realised that performance is degrading for this table, so we rolled back by restoring level "0" and level "1" backup. But here after the restored performance got more worst, run update statistics but it did not make any difference, any clue what could have gone wrong. 2) How do I find out which users are accessing TABLE-A, not using onstat -g sql or onstat -g ses command, need to know the systable names and the field to run the query. Thanks in advance. Sushil... _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Hi, Thanks for sending the script to check the users accessing a particular table. Sushil.. >From: "Juan Manuel Naranjo" <jn6426@Propal.com.co> >To: "Sushil Shir...." <sushilps@hotmail.com> >Subject: RE: Re.restore & table accessed by users. [67] Date: Wed, 22 Jan >2003 09:30:36 -0500 >MIME-Version: 1.0 >Received: from uniweb.net.co ([200.24.96.8]) by mc7-f37.law1.hotmail.com >with Microsoft SMTPSVC(5.0.2195.5600); Wed, 22 Jan 2003 06:33:31 -0800 >Received: from pro-m-yub-w-dan.propal.com ([200.24.98.51]) by uniweb.net.co >; Wed, 22 Jan 2003 09:21:31 -500 GMT >X-MimeOLE: Produced By Microsoft Exchange V6.0.5762.3 >content-class: urn:content-classes:message >Message-ID: <9F3479FBF1E60E42B347249C71D0B08DA70F08@pro-m-yub-w-dan> >X-MS-Has-Attach: yes >X-MS-TNEF-Correlator: Thread-Topic: Re.restore & table accessed by users. >[67] Thread-Index: AcLBr5MRmpurdYvRSTKz5B5GhKf+fAAcyjjw >Return-Path: jn6426@Propal.com.co >X-OriginalArrivalTime: 22 Jan 2003 14:33:32.0014 (UTC) >FILETIME=[3CD6A8E0:01C2C223] > > > >Cordialmente : > >Cordialmente: > >Juan Manuel Naranjo Arango >Administrador Infraestructura BASIS >Productora de Papeles S.A. ( PROPAL) >Tel: (572) 6512 411 >Fax: (572) 6694 345 > >-----Mensaje original----- >De: Sushil Shir.... [mailto:sushilps@hotmail.com] >Enviado el: martes, 21 de enero de 2003 18:48 >Para: ids@iiug.org >Asunto: Re.restore & table accessed by users. [67] > >Hi, > >Have 2 questions for you folks: > >1) We took backup, made some changes on the table for new indexes and >realised that performance is degrading for this table, so we rolled back >by >restoring level "0" and level "1" backup. But here after the restored >performance got more worst, run update statistics but it did not make >any >difference, any clue what could have gone wrong. > >2) How do I find out which users are accessing TABLE-A, not using onstat >-g >sql or onstat -g ses command, need to know the >systable names and the field to run the query. > >Thanks in advance. >Sushil... > >_________________________________________________________________ >Protect your PC - get McAfee.com VirusScan Online >http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > ><< who-access.sh >> _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail