Viewing 15 posts - 20,626 through 20,640 (of 49,552 total)
Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
February 2, 2012 at 10:47 am
Why do you want keepfixedplan? Are the compile times of this causing unacceptable load?
How did you identify that 4 plans were used?
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
February 2, 2012 at 10:46 am
Then take some windows exams and earn a couple windows certs. The MCDBA does not exist for any version later than 2000 and there's no comparable 'sql + windows +...
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
February 2, 2012 at 9:55 am
logicinside22 (2/2/2012)
I am looking for MCDBA certification path with SQL Server 2008 Certification.
No such thing. The MCDBA was a SQL 2000 certification, it was retired years ago.
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
February 2, 2012 at 9:46 am
snigdhandream (2/2/2012)
I have created a composite non-clustered index on 3 of the columns those are used frequently in where clause against that table.
You might want to take a read...
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
February 2, 2012 at 6:17 am
It sounds almost like something you'd use resource govenor for, except that is for connections not procedures. Maybe worth investigating
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
February 2, 2012 at 6:16 am
And bear in mind that it requires that the log becomes full, which causes problems anyway.
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
February 2, 2012 at 6:09 am
Error 50000 is a user-defined error. Check line 1769, look for the RAISERROR statement and see what the code is around that and the conditions that will cause the 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
February 2, 2012 at 2:36 am
Ok...
Name from sys.procedures. Parameters from sys.columns (join on object_id), definition from sys.sql_modules, you'll have to do some string parsing to get it out.
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
February 2, 2012 at 2:18 am
The memory grant property on the select or update operator.
I could only compare for the selects, as for the update you only posted one plan
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
February 1, 2012 at 4:40 pm
Nothing immediately jumps out looking at the exec plan, going to need those wait stats. Your DBA should know how to get a single query's wait_type and wait_resource
Also, did you...
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
February 1, 2012 at 4:02 pm
SQLKnowItAll (2/1/2012)
Can you give an example of a situation where you would choose not to do it
Just about all of them.
I would consider doing that if I had requirements that...
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
February 1, 2012 at 3:59 pm
Nope, that is not what I'm asking for.
When the query is running and when it is running slowly, get the query's wait_type and wait_resource. The aggregated server-wide wait stats are...
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
February 1, 2012 at 1:35 pm
There isn't any such relationship. SQL does not keep track of who modified what. If you need that info, you need triggers, trace, extended events or SQLAudit.
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
February 1, 2012 at 1:21 pm
Yes, if two people want to update the same row, one gets to update, one has to wait
With regards to locking, global temp tables are much like any other normal...
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
February 1, 2012 at 1:03 pm
Viewing 15 posts - 20,626 through 20,640 (of 49,552 total)