Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have custom page and it has a CbQ webpart alone, it actually performs a query against a single list which has only 800 items with 15 columns but it takes 8secs to load. I suspect a slowness in SQL, how I can conclude that it is an issue with the SQL. Sometimes I could see the long running queries in the ULS log.

Update
The filter columns are used in the CbQ webpart are not indexed, will it impact the overall performance?

If so, howmany columns can be used for Indexing that should not affect the performance again? also, how can I eusure that Index is created for that site column?

share|improve this question
    
one more doubt, what will happen if I have there CbQ in a page, is it all those 3 queries will execute Parallelly or one by one? –  Karthikeyan Apr 25 '11 at 16:44
    
They are executed one by one –  Anders Rask Apr 25 '11 at 19:31
add comment

3 Answers

It can be various issues that causes this. One way of getting a clue on whats going on is to enable developer dashboard.

See here for guidance on how to enable http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=189

Another option if you think this is SQL related, is to start up SQL Trace

share|improve this answer
    
Do we have the developer dashboard option in SharePoint 2007? or is there any alternative way of doing it in SharePoint 2007? –  Karthikeyan Apr 23 '11 at 13:47
    
Not that i know of. But try SQL Trace –  Anders Rask Apr 23 '11 at 17:04
    
From the SQL Trace, SQL does not take much time to complete the query.. –  Karthikeyan Apr 25 '11 at 16:26
    
Is the site generally slow? Are the db used for other purposes than SharePoint? –  Anders Rask Apr 26 '11 at 6:05
    
It is a shared physical machine with many SQL instances and ours is one of those..and it is just a PKS web-application which does not have data to be stored in the db..our DB size is ~1.5GB –  Karthikeyan Apr 26 '11 at 18:13
add comment

I would say the issue lies with the XSL rather than the SQL.

Do you have any custom XSL, and what data types are the 15 columns?

share|improve this answer
    
ok, will check the XSL & XML. those are mostly text and time field. –  Karthikeyan Apr 20 '11 at 17:43
    
this is default XSL comes with the PKS for sharepoint. –  Karthikeyan Apr 23 '11 at 12:15
add comment

If you think it is a SQL bottleneck, make sure you have object caching enabled.

share|improve this answer
    
we have already enabled the site collection object caching. –  Karthikeyan Apr 20 '11 at 17:41
    
it is executing the CAML Query every time though we have enabled the site collection object caching. is that an expected behavior? –  Karthikeyan Apr 25 '11 at 16:46
    
CQWP will cache the requests unless you disabled cahing in web part properties –  Anders Rask Apr 25 '11 at 19:29
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.