Forum Replies Created

Viewing 15 posts - 16 through 30 (of 42 total)

  • RE: How can I be a great DBA?

    Thanks Steve 😀

    How can I start, I think the problem I mention is because of something about the log, do you think so?, how can I start looking what it...


    Ana

    November 19, 2001 at 3:36 pm

    #420213

  • RE: Importing/comparing data from Access to SQLServer7

    I agree with Steve, I download the bundle sw, from RedGates and it is quit intresting, I am starting to use it. It is fine.

    Have a great...


    Ana

    October 31, 2001 at 10:38 am

    #419547

  • RE: Connection/Command Timeout

    Good morning 😀

    yesterday they told me that they make a truncate to a table (or something else) they delete the log and than ask me to run it again,...


    Ana

    October 26, 2001 at 10:15 am

    #419385

  • RE: Connection/Command Timeout

    Hi Andy, I try to run the plan that I made but I can not run it because it sayas that the Server Agent is not running, but if...


    Ana

    October 25, 2001 at 4:24 pm

    #419359

  • RE: Connection/Command Timeout

    Hi Andy, its me again, do you think it could be the transaction log?,

    I have my hands tied up 🙁

    could you please read your email PLEASE 😀

    Thanks


    Ana

    October 25, 2001 at 3:14 pm

    #419355

  • RE: Connection/Command Timeout

    Thanks Andy, you really cheer me up

    I couldn´t sleep last night thinking about this problem could you believe it??

    Binduram, so you run a DB Maint Plan??

    Thanks every body 😀


    Ana

    October 25, 2001 at 2:23 pm

    #419350

  • RE: Connection/Command Timeout

    Hi!, I got the information:

    DELETE FROM DEMAND_LINE_ITEM;

    StmtText |--Clustered...


    Ana

    October 25, 2001 at 11:20 am

    #419341

  • RE: Connection/Command Timeout

    Thanks Steve, 😀

    quote:

    You can do a SET SHOWPLAN_TEXT ON before running the query to get the query plan.

    Or SET STATISTICS IO ON

    Steve...


    Ana

    October 25, 2001 at 9:04 am

    #419338

  • RE: Connection/Command Timeout

    How can I do this "In QA, turn on the server trace, lets see how much IO is involved - could post that? It would also be helpful if you...


    Ana

    October 24, 2001 at 6:54 pm

    #419309

  • RE: Connection/Command Timeout

    Hi, Andy do you think that encreasing the LOCK_TIMEOUT in my sp can help?

    Thanks 🙂

    Ana


    Ana

    October 24, 2001 at 5:38 pm

    #419299

  • RE: Connection/Command Timeout

    Andy, the first step I don´t think I can do it because I don´t have that freedom in the server. I am looking the second step, I already identify...


    Ana

    October 24, 2001 at 5:22 pm

    #419298

  • RE: Connection/Command Timeout

    I really don´t know but I see it high too.

    quote:

    No , but I do see a high memory usage. I wonder if...


    Ana

    October 24, 2001 at 2:38 pm

    #419290

  • RE: Connection/Command Timeout

    Hi Binduram, did you resolve the problem??

    Have a nice day 😀

    quote:

    But will lock problems effect the connection timeouts


    Ana

    October 24, 2001 at 2:06 pm

    #419285

  • RE: SQL timing out

    Sorry if I ask but how do I do this "You should run that script in a console window, not QA. "

    Thanks 😀

    Ana


    Ana

    October 24, 2001 at 1:05 pm

    #419282

  • RE: Connection/Command Timeout

    Hi binduram, I have the same problem only with one table of the database, I think that it is a database problem, you have to check your commandtimeouts.

    Ana

    Edited by -...


    Ana

    October 24, 2001 at 12:29 pm

    #419273

    • Viewing 15 posts - 16 through 30 (of 42 total)