Viewing 15 posts - 13,486 through 13,500 (of 22,213 total)
Hey, whoa! If you take away the phrase "It works on my machine" you've just eliminated 2/3 of any conversation I have with developers. What are they supposed to say...
January 26, 2011 at 5:45 am
Little Nick (1/26/2011)
tq mam. your answer so sexy 🙂
Just so you know, this is a professional forum. That type of comment is serious breach of protocol. You should behave here...
January 26, 2011 at 5:42 am
Derrick Smith (1/25/2011)
isuckatsql (1/25/2011)
I ran an execution plan, but dont really have any experience in this area, so i opened a ticket with Microsoft.Thanks again!
If you post the execution plans...
January 25, 2011 at 1:34 pm
Then I suspect either the text is very small or FTI is not being used. Again, the exec plan should tell the tale.
January 25, 2011 at 12:28 pm
I'd check the execution plans. That's going to tell you what each operation is leading to. I would suspect that both LIKE and CONTAINS leads to a scan, but it...
January 25, 2011 at 12:07 pm
SAnjy N (1/25/2011)
Thanks, I have only remote access. And I am not comfortable with Execution Plans. How to read them!
If you search on the web you can find a...
January 25, 2011 at 11:47 am
Is anything else running on the servers? If not, it's SQL Server that is probably causing the issue. Do you have monitoring set up so you can observe the behaviors...
January 25, 2011 at 11:13 am
Good points Gus. This is meant to be my introductory session on execution plans (it's going, more or less intact, into my SQL Rally all day session). Thanks. Great feedback.
January 25, 2011 at 10:14 am
Not knowing how your backups are configured or running, it's hard to say. But it sounds like whatever process is running the backups either doesn't have that database included, or,...
January 25, 2011 at 9:32 am
It's not something I've run into. Can you post the specific error message, if any?
Is there any chance a different process is also calling the log backup procedure?
January 25, 2011 at 9:31 am
If you're not seeing CPU or Disk issues, I'd start looking for weird stuff. Do you have lots of connections unclosed? Are there uncommitted transactions? Stuff like that. Something that...
January 25, 2011 at 9:28 am
Another possibility is differences in the physical boxes. We had a production box once that had slower CPU's the dev box. Made us crazy for a while til we noticed....
January 25, 2011 at 9:26 am
scorpianprince (1/25/2011)
If huge transactions are happening and if the large insertions and deletions is a daily process then he don't have any other method.
If huge transactions are occurring daily that...
January 25, 2011 at 9:22 am
Viewing 15 posts - 13,486 through 13,500 (of 22,213 total)