Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

need one doubt clarification application team trying to execute a simple query Expand / Collapse
Author
Message
Posted Monday, December 3, 2012 4:04 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 40,428, Visits: 36,879
Not a picture of the exec plan, which is fairly useless. The execution plan saved to a file. Plus the view definition, the table definitions, the index definitions.

Please read the article that Opc posted in his first reply on this thread.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1391840
Posted Monday, December 3, 2012 4:22 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:03 AM
Points: 590, Visits: 1,327
the query is also in the execution plan out put and application team frequently check
this simple query to check the count ---->> select count(*) from acmt


Thanks
Naga.Rohitkumar
Post #1391843
Posted Monday, December 3, 2012 4:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:10 AM
Points: 5,221, Visits: 5,119
We need the execution plan as a SQLPLAN file.

We also need the CREATE VIEW definition

We also need the CREATE TABLE definition of all the tables in the query and or view

We also need all the CREATE INDEX definitions of all the indexes on all the tables in the query

We also need the FULL SQL STATEMENT used when generating the execution plan.

Please follow the links in my signature, on posting performance problems and how to post code and data. Without this we cannot help you further.

Remember we cannot see what you can see.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1391847
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse