Topic
  • 3 replies
  • Latest Post - ‏2013-12-17T23:43:38Z by DonaldN
JK_79
JK_79
2 Posts

Pinned topic ClearQuest 7.1.2.x - performance limitations with attachments?

‏2013-12-16T12:40:19Z |

Hello,

I use attachments with IBM Rational ClearQuest 7.1.2.9, based on SQL Server 2008 database.

Are there any known limitations which I must consider regarding file count and / or size of data attachments in the ClearQuest database?

 

Cheers,
Jürgen

  • DonaldN
    DonaldN
    287 Posts
    ACCEPTED ANSWER

    Re: ClearQuest 7.1.2.x - performance limitations with attachments?

    ‏2013-12-17T23:43:38Z  
    • JK_79
    • ‏2013-12-17T06:34:10Z

    Thanks Donald for this information.

    Do you also know performance issues with ClearQuest, when using Blobs excessivly?
    I would say that the limitation also lies with SQL Server 2008. If the database doesn't exceed the known storage limitations as shown in the technet-Article, I think that I can outrule performance problems while using ClearQuest. But I am not sure about this...

     

    Cheers,

    Jürgen

    I am not aware any performance issues with ClearQuest attachments. Since you use the word "excessively", there is one case that you should be aware of. If you allow the SQL Server data file to expand automatically so as to accommodate the unexpected large BLOBs, the SQL Server can be very slow when the data file is being expanded (of course it depends on how fast your storage system is). Another thing to note is that when a user is downloading a large attachment via the internet (from ClearQuest Web) without knowing the actual attachment size and network speed, he/she may complain that ClearQuest is slow.

  • DonaldN
    DonaldN
    287 Posts

    Re: ClearQuest 7.1.2.x - performance limitations with attachments?

    ‏2013-12-16T23:30:30Z  

    The limitation is with the back end database - in this case, SQL Server 2008. The maximum size of a column is 2^31-1 (2GB).

    http://www-01.ibm.com/support/docview.wss?uid=swg21128134

    http://technet.microsoft.com/en-us/library/ms143432%28v=sql.100%29.aspx

  • JK_79
    JK_79
    2 Posts

    Re: ClearQuest 7.1.2.x - performance limitations with attachments?

    ‏2013-12-17T06:34:10Z  
    • DonaldN
    • ‏2013-12-16T23:30:30Z

    The limitation is with the back end database - in this case, SQL Server 2008. The maximum size of a column is 2^31-1 (2GB).

    http://www-01.ibm.com/support/docview.wss?uid=swg21128134

    http://technet.microsoft.com/en-us/library/ms143432%28v=sql.100%29.aspx

    Thanks Donald for this information.

    Do you also know performance issues with ClearQuest, when using Blobs excessivly?
    I would say that the limitation also lies with SQL Server 2008. If the database doesn't exceed the known storage limitations as shown in the technet-Article, I think that I can outrule performance problems while using ClearQuest. But I am not sure about this...

     

    Cheers,

    Jürgen

  • DonaldN
    DonaldN
    287 Posts

    Re: ClearQuest 7.1.2.x - performance limitations with attachments?

    ‏2013-12-17T23:43:38Z  
    • JK_79
    • ‏2013-12-17T06:34:10Z

    Thanks Donald for this information.

    Do you also know performance issues with ClearQuest, when using Blobs excessivly?
    I would say that the limitation also lies with SQL Server 2008. If the database doesn't exceed the known storage limitations as shown in the technet-Article, I think that I can outrule performance problems while using ClearQuest. But I am not sure about this...

     

    Cheers,

    Jürgen

    I am not aware any performance issues with ClearQuest attachments. Since you use the word "excessively", there is one case that you should be aware of. If you allow the SQL Server data file to expand automatically so as to accommodate the unexpected large BLOBs, the SQL Server can be very slow when the data file is being expanded (of course it depends on how fast your storage system is). Another thing to note is that when a user is downloading a large attachment via the internet (from ClearQuest Web) without knowing the actual attachment size and network speed, he/she may complain that ClearQuest is slow.