Viewing 15 posts - 16 through 30 (of 41 total)
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...
November 19, 2001 at 3:36 pm
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...
October 31, 2001 at 10:38 am
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,...
October 26, 2001 at 10:15 am
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...
October 25, 2001 at 4:24 pm
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
October 25, 2001 at 3:14 pm
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 ๐
October 25, 2001 at 2:23 pm
Hi!, I got the information:
DELETE FROM DEMAND_LINE_ITEM;
StmtText |--Clustered...
October 25, 2001 at 11:20 am
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...
October 25, 2001 at 9:04 am
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...
October 24, 2001 at 6:54 pm
Hi, Andy do you think that encreasing the LOCK_TIMEOUT in my sp can help?
Thanks ๐
Ana
October 24, 2001 at 5:38 pm
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...
October 24, 2001 at 5:22 pm
I really donยดt know but I see it high too.
quote:
No , but I do see a high memory usage. I wonder if...
October 24, 2001 at 2:38 pm
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
Sorry if I ask but how do I do this "You should run that script in a console window, not QA. "
Thanks ๐
Ana
October 24, 2001 at 1:05 pm
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 -...
October 24, 2001 at 12:29 pm
Viewing 15 posts - 16 through 30 (of 41 total)