Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum SQL Server high CPU usage when running searches in Projectwise
    • Sign In

    • State Not Answered
    • Replies 1 reply
    • Subscribers 60 subscribers
    • Views 1180 views
    • Users 0 members are here
    • Projectwise CPU search searching

    SQL Server high CPU usage when running searches in Projectwise

    PM68
    Offline PM68 over 7 years ago

    Hi All.

    I regularly run some saved Global searches in Projectwise. While I run them I have noticed on the server that SQL Server will use 50% CPU until the search results are displayed. This doesn't cause any issue unless another process is using a lot of the CPU at the same time.

    My question is: Is it normal for a search to cause SQL server to use so much of the CPU? Thanks.

    • Sign in to reply
    • Cancel
    Parents
    • Dana Guthrie
      0 Offline Dana Guthrie Thu, Feb 25 2016 9:59 AM
      It is normal for the SQL servers CPU to jump during complicated or broad searches. Queries that search the entire database for a certain set of parameters will likely spike the CPU. If possible, try to narrow the searches down to a certain folder structure or environment.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Reply
    • Dana Guthrie
      0 Offline Dana Guthrie Thu, Feb 25 2016 9:59 AM
      It is normal for the SQL servers CPU to jump during complicated or broad searches. Queries that search the entire database for a certain set of parameters will likely spike the CPU. If possible, try to narrow the searches down to a certain folder structure or environment.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Children
    No Data

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies