|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Help..I'm being thrown under the bus...Hi Folks!
I'm working with a small group and I'm writing a VB app that gets data from a SQL Server. One or more of my collegues has found a way to make my queries timeout. The database has about 15% usage and all the usage statistics are low. Most of the time the queries work fine but I'm certain that some people have figured a way to sabotage my work. They now th specific tables I'm accessing. Get any ideas? Do you need a dose of haloperidol? Why do you think they're trying to
sabotage you? Is it possible that you just need to think about some better indexes? Show quote "Bob" <Go1***@Yahoo.Com> wrote in message news:1125078492.756810.252150@o13g2000cwo.googlegroups.com... > > Hi Folks! > > I'm working with a small group and I'm writing a VB app that gets data > from a SQL Server. > > One or more of my collegues has found a way to make my queries timeout. > The database has about 15% usage and all the usage statistics are low. > > Most of the time the queries work fine but I'm certain that some people > have figured a way to sabotage my work. They now th specific tables I'm > accessing. > > Get any ideas? > > One or more of my collegues has found a way to make my queries timeout. Wow, just because you're paranoid doesn't mean they're not out to make your queries time out. Seriously, now, why do you jump to the conclusion that someone is throwing you under the bus, as opposed to, I don't know, bad design or too much data or slow hardware or flaky network connection or outdates statistics or index fragmentation or lack of indexes or just too much data or five hundred other factors that affect query time and performance? When you think someone (or something) is deadlocking the system, see what
processes are currently being blocked by executing: sp_who2 The SPID of the blocking process will show in the column titled [blkby]. To see what query or command was last executed by this SPID, execute: DBCC INPUTBUFFER(<spid>) Also read up on: http://support.microsoft.com/default.aspx?scid=kb;en-us;832524 http://support.microsoft.com/default.aspx?scid=kb;EN-US;224453 http://www.sqlservercentral.com/columnists/skumar/tracingdeadlocks.asp Show quote "Bob" <Go1***@Yahoo.Com> wrote in message news:1125078492.756810.252150@o13g2000cwo.googlegroups.com... > > Hi Folks! > > I'm working with a small group and I'm writing a VB app that gets data > from a SQL Server. > > One or more of my collegues has found a way to make my queries timeout. > The database has about 15% usage and all the usage statistics are low. > > Most of the time the queries work fine but I'm certain that some people > have figured a way to sabotage my work. They now th specific tables I'm > accessing. > > Get any ideas? > I just ran sp_who3 and you're absolutely right! They're after you!
But seriously: why would you think that? ML My aluminum hat sprung a leek! The cosmic rays are getting through! Help!
Show quote "ML" <M*@discussions.microsoft.com> wrote in message news:DF58DD36-3D26-46A2-AE4B-9A707E405A03@microsoft.com... > I just ran sp_who3 and you're absolutely right! They're after you! > > But seriously: why would you think that? > > > ML You might google for the "aluminium_patch.exe". It runs in the Windows for
the deluded. But don't tell anyone, coz' they be all evil! (I think my hair dryer is tapped!)  
Other interesting topics
|
|||||||||||||||||||||||
