GP SQL Server Performance monitoring, problem with CPU related loc

The past week our GP SQL Server has been locking up.  All GP clients (around 
15) lockup and are not able to do anything within the app.  When this happens 
the CPU on the server maxes out.  It last for around 15 minutes then the CPU 
goes back to normal and everyone can start to use the GP clients again.

Is there a way to see what is happening?  For instance maybe its a 
batch/transaction/query/report etc. that a user is running that is causing 
this.  Is there a log I can review or something to help me pinpoint what 
process is doing this?

Thanks for your input!
0
Utf
3/31/2010 2:11:01 PM
greatplains 29623 articles. 6 followers. Follow

5 Replies
1321 Views

Similar Articles

[PageSpeed] 54

Hi,
Can you please provide a little more infos about your SQL server ?
version of SQL, SP, OS version, HW, etc.
There are several reason that could led your server to a slowdown...
Does it happen every day ? is it random ? at which time during the day ?
Thanks for posting more details if you want a less vague response...

-- 
Hope this helps,
Have a great time
Beat

+-+-+-+-+-+-+-+
B. Bucher
Dynamics GP 10 Sr. Sys Admin
www.fti-ibis.com
+-+-+-+-+-+-+-+

travisalex wrote:
> The past week our GP SQL Server has been locking up.  All GP clients (around
> 15) lockup and are not able to do anything within the app.  When this happens
> the CPU on the server maxes out.  It last for around 15 minutes then the CPU
> goes back to normal and everyone can start to use the GP clients again.
>
> Is there a way to see what is happening?  For instance maybe its a
> batch/transaction/query/report etc. that a user is running that is causing
> this.  Is there a log I can review or something to help me pinpoint what
> process is doing this?
>
> Thanks for your input!

0
Beat
3/31/2010 4:41:34 PM
The first thing I would do when the lockup occurs is start up SQL Server 
Management Studio and open the Activity Monitor. Look in the 'Wait Type' 
column for any text; this may give you a clue as to what might be happening. 
You can double-click on a specific line in the Monitor, and if you're lucky, 
you can see the code or stored procedure that's running - which may also give 
you a clue as to what's going on.

If that doesn't help you figure out the issue, then you'll need to get into 
more exotic means of tracing activity.

Do you know what the users are doing when this happens? Typically, two or 
more people are trying to access the same database table and everyone has to 
wait until the first transaction finishes. I've run into this when two people 
try to post inventory transaction batches at the same time...among other 
things.



-- 
Bud Cool
Microsoft Certified Business Management Solutions Specialist, GP 9.0 
Financials
Currently supporting: GP 9.0, SP4


"travisalex" wrote:

> The past week our GP SQL Server has been locking up.  All GP clients (around 
> 15) lockup and are not able to do anything within the app.  When this happens 
> the CPU on the server maxes out.  It last for around 15 minutes then the CPU 
> goes back to normal and everyone can start to use the GP clients again.
> 
> Is there a way to see what is happening?  For instance maybe its a 
> batch/transaction/query/report etc. that a user is running that is causing 
> this.  Is there a log I can review or something to help me pinpoint what 
> process is doing this?
> 
> Thanks for your input!
0
Utf
3/31/2010 4:48:01 PM

"Beat Bucher" wrote:

> Hi,
> Can you please provide a little more infos about your SQL server ?
> version of SQL, SP, OS version, HW, etc.
> There are several reason that could led your server to a slowdown...
> Does it happen every day ? is it random ? at which time during the day ?
> Thanks for posting more details if you want a less vague response...
> 
> -- 
> Hope this helps,
> Have a great time
> Beat
> 
> +-+-+-+-+-+-+-+
> B. Bucher
> Dynamics GP 10 Sr. Sys Admin
> www.fti-ibis.com
> +-+-+-+-+-+-+-+
> 

Thanks for the reply.

SQL 2008 Standard 64bit, version 10.2531.0 (i think SP1 that is?)
Server 2008 standard
GP 10.00.1193

The CPU spikes are random, I have not been able to find a pattern.  It 
happens about 4 times a day and last for around 15 minutes.  It is happening 
just during business hours...

I have canvassed GP users to see if there is any new 
reports/batches/transactions etc. happening at the time of the lockup.  Of 
course no one knows of anything.  Let me know if I am missing something info 
wise, thanks.
0
Utf
4/1/2010 3:21:01 PM
Is it 4 times a day with a pattern?  Like 10am, 12pm, 2pm, 4pm?  Do you have 
any backups or jobs that may be running on that kind of schedule? What else 
is running on that server?

-- 
Victoria Yudin
Dynamics GP MVP 2005-2010
Want to use Crystal Reports with GP?
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com


"travisalex" <travisalex@discussions.microsoft.com> wrote in message 
news:9DD939C3-B0FC-4A2E-A23C-4F88A0326576@microsoft.com...
>
>
> "Beat Bucher" wrote:
>
>> Hi,
>> Can you please provide a little more infos about your SQL server ?
>> version of SQL, SP, OS version, HW, etc.
>> There are several reason that could led your server to a slowdown...
>> Does it happen every day ? is it random ? at which time during the day ?
>> Thanks for posting more details if you want a less vague response...
>>
>> -- 
>> Hope this helps,
>> Have a great time
>> Beat
>>
>> +-+-+-+-+-+-+-+
>> B. Bucher
>> Dynamics GP 10 Sr. Sys Admin
>> www.fti-ibis.com
>> +-+-+-+-+-+-+-+
>>
>
> Thanks for the reply.
>
> SQL 2008 Standard 64bit, version 10.2531.0 (i think SP1 that is?)
> Server 2008 standard
> GP 10.00.1193
>
> The CPU spikes are random, I have not been able to find a pattern.  It
> happens about 4 times a day and last for around 15 minutes.  It is 
> happening
> just during business hours...
>
> I have canvassed GP users to see if there is any new
> reports/batches/transactions etc. happening at the time of the lockup.  Of
> course no one knows of anything.  Let me know if I am missing something 
> info
> wise, thanks. 

0
Victoria
4/2/2010 3:02:23 PM
On Apr 2, 8:02=A0am, "Victoria [MVP]" <victo...@flex-solutions.com>
wrote:
> Is it 4 times a day with a pattern? =A0Like 10am, 12pm, 2pm, 4pm? =A0Do y=
ou have
> any backups or jobs that may be running on that kind of schedule? What el=
se
> is running on that server?
>
> --
> Victoria Yudin
> Dynamics GP MVP 2005-2010
> Want to use Crystal Reports with GP?http://www.flex-solutions.com/gprepor=
ts.html
> blog:http://www.victoriayudin.com
>
> "travisalex" <travisa...@discussions.microsoft.com> wrote in message
>
> news:9DD939C3-B0FC-4A2E-A23C-4F88A0326576@microsoft.com...
>
>
>
>
>
> > "Beat Bucher" wrote:
>
> >> Hi,
> >> Can you please provide a little more infos about your SQL server ?
> >> version of SQL, SP, OS version, HW, etc.
> >> There are several reason that could led your server to a slowdown...
> >> Does it happen every day ? is it random ? at which time during the day=
 ?
> >> Thanks for posting more details if you want a less vague response...
>
> >> --
> >> Hope this helps,
> >> Have a great time
> >> Beat
>
> >> +-+-+-+-+-+-+-+
> >> B. Bucher
> >> Dynamics GP 10 Sr. Sys Admin
> >>www.fti-ibis.com
> >> +-+-+-+-+-+-+-+
>
> > Thanks for the reply.
>
> > SQL 2008 Standard 64bit, version 10.2531.0 (i think SP1 that is?)
> > Server 2008 standard
> > GP 10.00.1193
>
> > The CPU spikes are random, I have not been able to find a pattern. =A0I=
t
> > happens about 4 times a day and last for around 15 minutes. =A0It is
> > happening
> > just during business hours...
>
> > I have canvassed GP users to see if there is any new
> > reports/batches/transactions etc. happening at the time of the lockup. =
=A0Of
> > course no one knows of anything. =A0Let me know if I am missing somethi=
ng
> > info
> > wise, thanks.- Hide quoted text -
>
> - Show quoted text -

Just a note that I saw that exact same thing at a client and it was
Norton on the server doing virus scans

Jim
0
Jim
4/12/2010 6:40:16 AM
Reply:

Similar Artilces:

Favourite GP Feature
What are some of the members of this boards favourite GP feature or trick? I am looking to compile a list of simple tricks users can learn quickly to help them out. Do an Interent seach for GP 50 tips and tricks. You'll get results from Convergence 2010 presentations. some good tips in there. Also search for 50 more tips and tricks. "Adam" wrote: > What are some of the members of this boards favourite GP feature or trick? > > I am looking to compile a list of simple tricks users can learn quickly to > help them out. Try this blog for a da...

Problem with CFTPConnection
Hi I've an application that connects to an FTP Server and uploads a big directory (size over 500 MB). Now what happens is that after sometime the application stops uploading files and stays idle. The FTP server connection timeout value is set to 2 minutes. So the server seeing the connection idle for two seconds, disconnect the session and no more file is uploaded. On debugging I found out that after some time CFTPConnection.PutFile() method hangs on some random file and stays like that for 5 minutes (default send timeout value of CFTPSession). During this time the server connection timeo...

Excel 97 Win XP calc problem?
I have a machine running office 97 and Win XP. I have seen posts stating it runs fine, but I don't know how man people use spreadsheets that require a hard calculation: Excel will not force a calculation. i.e. ctrl-alt-f9 does not cause full workbook calculation as required. Meaning cells do not update and it doesn't calculate unless you clic in the cell to edit and hit enter. neither does the "Calc Now" button. Auto or manual calculation mode has no effect. Anybody else have this problem -- Message posted from http://www.ExcelForum.com Make sure that both the SR1 a...

Here is fix for Windows file problems
If you have installed a Windows update and started having problems opening, closing, copying files, see: http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.misc&mid=1fe358b1-c8eb-4217-ad2a-4b9fcf741916 A better solution is offered at http://support.microsoft.com/kb/918165 "Problems in Windows Explorer or the Windows shell after you install security update MS06-015". Patricia Shannon wrote: > If you have installed a Windows update and started having problems opening, > closing, copying files, see: > > http://ww...

Statistics Creation on SQL 2005
My db has "auto create statistics" on. For some reason, there are quite a few indexes that don't have statistics. What could be the cause? Thanks in advance Sorry about the bother. I got my answer. "auto create statistics" proces only creates statistics if columns are found in where clause. "RG" wrote: > My db has "auto create statistics" on. For some reason, there are quite a > few indexes that don't have statistics. > > What could be the cause? > > Thanks in advance > My db has "auto...

Monitor Server in 2003?
Hi all, After installing Exchange 2003 SP1, I'm having some issues monitoring exchange server via scripting. 1. I can no longer get any instances from "Win32_PerfRawData_ESE_DatabaseInstances" via scripting. 2. The property "LogGenerationCheckPointDepth" does not even appear as a property of "Win32_PerfRawData_ESE_DatabaseInstances". (I checked this with WMI CIM studio) I can still get the LogGenerationCheckPointDepth from performance monitor. The following code verifies what I've seen in WMI CIM studio: set RawProc = GetObject("winmgmts:\\r...

CRM Outlook Client Configuration Wizard Problem
CRM 4.0 - Microsoft Outlook Client Guys, We've Microsoft CRM 4.0 Server roll up 8 as well as CRM Outlook Client on the same roll up version. Our Internal Web Access works without problems users get to it and they're automatically authenticated. IFD Development is the same way except they're prompt through a login page for their username and password when they're coming from an external network. Ever since we moved to a new facility users are experiencing problems connecting to CRM using their outlook client, I have a test machine where I have the CRM Outlook Client ins...

How to make Run Integration work in GP 10
Can anyone tell me how to make the Run Integration tool work in GP 10. We just did our first client upgrade to GP 10 and the client has only 1 integration that they used to be able to run via the RUN INTEGRATION Tool. Any help would be greatly appreciated. -- Tammy Chavez I have the same probelm...did you get any answers to this? I have to go into Integration Manager to run it b/c Tools>Run Integration does nothing. I even checked the ini files to make sure the path is correct. "Tammy Chavez" wrote: > Can anyone tell me how to make the Run Integration tool work in...

Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching forever and havn't found a hint yet. I have multiple domains setup on my exchange server. Lets say abc.com, def.com, and hij.com. We only send email with @abc.com but can receive from any domain name. Recently we merged with another company and we brought back their email to our server, lets say xyz.com. Now I configured a new recipient on Exchange 2003, so I now have two policies. The first policy has the three original domains in it with @abc.com as the primary domain. In the second policy I have configured xyz.com t...

Problem with Update function of CRecordSet class
Hi All When I use from Update function of CRecordSet class, it apply to table after a few time(for example 1 second) when I need to see it at time. Thanks ...

Outlook Mail via a PROXY SERVER?
If I am using a shared Internet service on a second computer using a PROXY server on the host (first) computer. I can access the net using the PROXY settings on the Internet explorer. However, how do I download mail with OUTLOOK 2000? The proxy server is CCPROXY from YoungZSoft (this runs on XP) and it has the MAIL Settings enabled but the difficulty is what to do on the Second computer? Thanks, -- John jrg_REM_SPAM@bigpond.net.au That would be determined by the proxy manufacturer - check with their support. JM7 wrote: > If I am using a shared Internet service on a second computer ...

Problem with macro assigned to custom toolbar button
Problem with macro assigned to custom toolbar button I am having a probelm with macros assigned to a custom button on custom button. I am using excel 2000. 1. I have created a macro called "Jump" in a workbook named "Test1" 2. I then created a custom toolbar and added a custom toolbar button t that toolbar. 3. Through the customize dialog box I assign the Macro "Jump" to th custom button. Everything works fine UNTIL. If I do a SAVE AS for the workbook "Test1" and call it something els like "Test2" and then close "Test2" an...

OL2002 Problem : HELP, SOS, MAYDAY
Hi, I have an IMAP account and OL2002 as client. I have checked for my account ( tools, send/receive settings, define send/receive groups, <my_account>, edit) download item description only. It works only the first time I start OL2002, but it does not work anymore for subsequent automatic/manual send/receive operations. Please could someone really help me ? Thank you in advance, Patrick ...

request to solve my problem #5
hello friends this is vijay,i got a problem while doing my project based on vc++ (i.e)"How to implement Fit Window feature in VC++6.0 in an MDI Application" if any of you got any idea about that please do reply me with the proceedure.i will be waiting for your reply bye with regards vijayprasadreddy ...

Excel. I am having a problem with hidden text
As I type text in some cells, it does not always dispaly if it exceeds the cell length. I wish to keep the cell lenghts for the entire document, but do wish for teh text in that particular row to be displayed. How about if you select that cell, then format|cells|alignment tab|check wrap text And with that row selected format|row|autofit SHR77 wrote: > > As I type text in some cells, it does not always dispaly if it exceeds the > cell length. I wish to keep the cell lenghts for the entire document, but do > wish for teh text in that particular row to be displayed. -- Da...

Performance By Investment Account
I've been trying to analyze the return calculations that MS Money provides in both the Portfolio Manager and also the Performance by Investment Account. One curious thing that I've come across and had previously not paid attention to is a feature in the Performance by Investment Account. If you click on "Customize' for this report, under the "Rows & Columns" tab there is a customizable setting called "Do not show performance based on data of less than: xx days." It defaults to 90 days. Does anyone know if this feature actually does anything? I'v...

Macros not performing correctly
I recorded a macro to place a vlookup formula in four cells that are side by side. When I run the macro it only performs the first task, it does not go on to do the other three. I used the tab key to go to the next cell while recording the macro, I don't know if that's why it's not working or if it's something else. The script looks like this: Sub EERates() ' ' EERates Macro ' Macro recorded 3/4/2005 by BCBSOK ' ' ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)" Range("F15").Select ActiveCell.FormulaR1C...

SQL Server Connection Failed
Hi everybody, this is my scenario: 1. Windows Server 2008 2. WSS 3.0 + MOSS 2007 3. SQL Server 2008. i'm having this problem: "Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 72.55.191.137]". in this momment i can't see any application from sharepoint. somebody knows how can i do? i don't change the sa password. i don't change anything in the sharepoint configuration. since two days ago i'm having this problem. pls, is very urgent, because i have to deliver this server the next monday to the...

GP SP#2 hangs with sa and Collections Issue
I just installed 8.0 SP#2 (ran the script that it says to run cuz we had upgraded from previous version to remove dups in smartlist tables) and when I log into GP as sa, it hangs and CPU sits at 100%. When I was able to log in previously to SP#2, I constantly received errors about the CN_Collector_MAIN table with invalid column names etc. I've deleted the table, then re-ran the create tables, but it keeps coming back with this error. I've even gone into file > maintenance > sql and deleted and recreated the table, but then get "number of results doesn't match ...

Exchange server crashed, please help....! Need to restore two priv.edb and pub.edb files into one....!
Hi Guys, I was wondering if I could get some help with the following problem we are having on our company. Here is the scenario; Our Windows NT 4.0 SP4a server running Exchange 5.5 SP4 crashed (Server 1) due to the exchange database reaching its 16 Gig's max limit. I went ahead and moved some mailboxes' e-mails to a few .pst files in order to make some space. This worked ok. Then, I decided to build another exchange server (Server 2) to moved some mailboxes and alleviate the load. Once the server was ready and configured as part of the current exchange site, I went ahead and move...

Changing ip address of exchange server #2
Hi, I have a back-end server and a smtp server in DMZ. I want to change ip address of back-end server. are there any issues? all incoming and outgoing emails are going via smart host. Hi, No issues at all as long as you remember to change all the references to this server in your firewall, SMTP scanner etc. Leif "Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message news:FE5927A1-D20D-4C6B-991F-2E1EFD19434D@microsoft.com... > Hi, > > I have a back-end server and a smtp server in DMZ. > > I want to change ip address of back-end server. are ...

Backing up databases on remote SQL
Hi, I recently followed one of the MS articles on how to move GP 9 sql database to a different server. Everything went well except when trying to run the backup option from the GP9 server. I currently have a server with GP9 installed and another server with SQL and the GP databases. When I try to run the backup from the backup option on the GP server it says " You must be on the server machine to perform this task". presume this is because the SQL is no longer on that server. The SQL server has a backup routine of its own, but I would like our finance users to have the ability...

China + Dynamics GP
We are opening a distribution center in China and was wondering if anyone else is currently using Dynamics GP and any form of EDI process with China. We are considering what would be the best way of handling. Due to security risks, we are wary of allowing RDP/term serv access. So one idea was to give them a laptop with GP/Sql Server/Integration Manager. Since they couldn't connect to us they would have a separate database. This would then involve exports and imports between the 2 company locations to a neutral site (such as FTP). Not sure yet if we will be mirroring the datab...

ANN: Optimizing the Performance of Microsoft Dynamics CRM 3.0 white paper
Hi, the White Paper "Optimizing the Performance of Microsoft Dynamics CRM 3=2E0" is now available: http://go.microsoft.com/fwlink/?LinkID=3D80916=20 Regards Nicolas F=FChrs ...

Outlook, Palm Pilot, and Exchange Server
I'm using Outlook with an Exchange Server (2000 Small Business). I installed the software for the Palm Pilot and now it prompts with a dialog box for the user to chose the following when they reply, forward or reply to all on an e-mail message. A Program is trying to access e-mail addresses you have stored in Outlook. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No". Allow access for (if you check the box) it gives 1, 2, 5 and 10 minutes. If you say no it lets you reply, forward, and reply to all. This is a nuisance more than ...