Viewing 15 posts - 30,121 through 30,135 (of 49,552 total)
Say what?
http://www.sqlservercentral.com/Forums/Topic1000851-20-1.aspx
Who's having luck with reading the tea leaves lately? Mind applying those divination skills to a QL2300 error?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 1:38 pm
Eh?
What's a QL2300 error? What's the message? What's the context?
Honestly I don't have a clue what you're asking. If you want some useful help, I think you're going...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 1:36 pm
Are you seeing this in the job history as an error from a specific job? If so, check what that job is doing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 12:43 pm
Please post errors in the body of the post. The title and description both get cut off.
Now, what's the problem?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 12:18 pm
TheSQLGuru (10/7/2010)
I wonder if the top 10 posters aren't 10 or more percent of the total posts.
If you do the maths, it works out that the top...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 11:49 am
Quick answer: Typically you don't.
Please read through this - Managing Transaction Logs[/url]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 11:34 am
Switch to simple recovery model. Run a checkpoint.
Once that's done, shrink the log to a reasonable size (NOT 1). Maybe start at 10 or 15 GB (as a rough guess)
Then...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 11:30 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 8:44 am
All the info you need is here: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 8:23 am
vijay1327-891581 (10/7/2010)
But the problem is the company does NOT allow to run the profiler due to some policies.
Do they forbid server-side traces as well (thought that is a bit...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 7:08 am
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 3:43 am
Eh?
I don't know what you're asking, what the context is or anything. If you want help you're going to have to give a fair bit more information about the problem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 3:39 am
It's not the procedure that's the problem, it's the function.
Edit: Just realised that you never gave me the definition of the main function (EXECS.tblExecutionTransaction). Please can you?
That there's a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 2:47 am
Yup. Catch-all type query. See the first link Dave posted.
That will never perform well and recompiles will not help. SQL will generate a plan that is safe for all parameter...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 2:27 am
Please post the definition of that function.
The reason that SQL caches plans is simple. Optimisation is a hard, difficult, CPU-intensive process. It's getting more and more CPU intensive as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2010 at 2:08 am
Viewing 15 posts - 30,121 through 30,135 (of 49,552 total)