Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

how to trouble shoot CPS slowness?

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

56 Views

RSS

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

I was wondering how people troubleshoot CPS slowness? for example, if you suspect a user is running a huge report, how can you find out what they are running and who is running it? if you suspect the sql server is the issue, what query/commands do you use? if you suspect the terminal server, what do you look for? I usually check the memory, harddrive, and cpu usage. They seem the same whether CPS is runnig normal or slow.

Any tips/trick would be appreciated. Thanks.

Posted : June 10, 2013 1:25 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

You can first check the task manager on the server that your SQL Server is running on to make sure it is SQL that is the cause. Then you can run Activity Monitor on the SQL server to get an overview of what's going on in SQL.

If we don't find anything here, we usually have to restart the server that is running SQL.

Posted : June 10, 2013 1:46 am

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

I always check the task manager and activity monitor but never really noticed anything. is there something i'm looking for in the activity monitor?

Posted : June 10, 2013 2:00 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

If the task manager on the server isn't showing anything, then it's not SQL giving you slowness. You're bottle-necking somewhere else. The server will show 100% CPU usage and/or 100% memory usage when SQL is your bottle-neck.

When looking at the Activity Monitor, I look for processes taking up a lot of memory and also the Recent Expensive Queries can give you an idea of what was ran recently that might have slowed things down.

Posted : June 10, 2013 2:08 am

georgea

(@georgea)

Posts: 76

Estimable Member

I had a ton of issues awhile back, here are some things you can do.

1. Open up SQL Manager, run an analyzer and see if you can see some major spikes on the CPU column. This will tell you user and query that is being executed.

2. You can also run a report from SQL that explains what queries are utilizing the CPU the most.

3. Another way is to ask everyone who runs reports. Then take all of those reports in the evenign or off hours, run them one by one and see what spikes the CPU the most. Then modify that report so it does not perform porly.

4. Last, always check to make sure you have enough memory, disk space, and are utilizing your server to the max.

If you need any help feel free to contact me.

George

[email protected]

Posted : June 26, 2013 3:30 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0