Viewing 15 posts - 46,156 through 46,170 (of 49,552 total)
Profiler or a server side trace.
If you want to see the queries within the procs, you want the sp:StmtCompleted event.
Be aware that if your server is busy the trace...
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
June 20, 2008 at 12:23 am
Depends on the queries that use that table. There's no hard rule.
You should have a clustered index. You should have enough nonclustered indexes on different columns that the frequently run...
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
June 19, 2008 at 7:38 am
Do you have a backup of that database?
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
June 19, 2008 at 7:34 am
What's your question?
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
June 19, 2008 at 7:31 am
Main difference between 2000 and 2005 is that in 2005 you can alse add columns as INCLUDE columns insted of as part of the key. Makes it a lot easier...
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
June 19, 2008 at 7:22 am
Ah. A form of serverside trace.
I thought for a moment that I'd missed a feature like 2005's default trace. :hehe:
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
June 19, 2008 at 6:58 am
Mscode_Pro (6/19/2008)
So the two ways are impossible
What ways are impossible?
I'll be wait for any solutions
Be patient. We're all volunteers here. We're not paid to answer forum questions.
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
June 19, 2008 at 6:52 am
<eyes glaze over> Right....
In addition to Grant's comments...
You have a lot of branching logic within the proc (if.. else...).
That kind of thing tends to lead to sub-optimal execution plans,...
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
June 19, 2008 at 6:50 am
Grant Fritchey (6/19/2008)
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
June 19, 2008 at 6:33 am
Do you have a backup of msdb?
If you look in the SQL log file (the error log), are there any entries that indicate why the database is suspect?
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
June 19, 2008 at 6:27 am
Bookmark lookups occur when SQL uses a nonclustered index to evaluate the rows required for a query. If the nonclustered index does not contain all the columns needed for 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
June 19, 2008 at 6:25 am
Make sure that the users who use the appliction don't have rights to stop services (not SQL permissions, windows level permissions). Make sure no one but the server admins can...
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
June 19, 2008 at 6:11 am
Different join means a different execution plan. SQL probably generated one that doesn't have the same massive internal tables.
Can you post the plan with the outer join? I'd like to...
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
June 19, 2008 at 4:40 am
Vladan (6/18/2008)
The data types in Inserted are the same as in the actual table.
Good point. Would need 2 columns then. 1 a varchar that the insert puts the 'date' into,...
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
June 19, 2008 at 4:13 am
Service packs for which version of SQL? 7, 2000, 2005?
As for what differes, there's no single answer to that. Each of the service packs for each version fixes different things....
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
June 19, 2008 at 2:48 am
Viewing 15 posts - 46,156 through 46,170 (of 49,552 total)