Forum Replies Created

Viewing 15 posts - 16 through 30 (of 41 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...

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

  • 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,...

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

  • 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

  • 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 ๐Ÿ˜€

  • RE: Connection/Command Timeout

    Hi!, I got the information:

    DELETE FROM DEMAND_LINE_ITEM;

    StmtText |--Clustered...

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

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

  • RE: Connection/Command Timeout

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

    Thanks ๐Ÿ™‚

    Ana

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

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

  • RE: Connection/Command Timeout

    Hi Binduram, did you resolve the problem??

    Have a nice day ๐Ÿ˜€

    quote:


    But will lock problems effect the connection timeouts


    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

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

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