| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-08-13 : 17:40:45
|
| Hi, Everything seems to be working after I applied service pack 3a to our development server but I have some slowness issues. For example we have an application server on the same box and it looks like it is taking time to access database but not via Query Analyzer or 2-tier.If everything is on the same box, so you think SP3a can cause slowness/difficulties in access to db ?The problem is not processing time but time taken by the process from initiated state to processing state.Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-13 : 17:44:53
|
| I have not experienced any problems with service pack 3a. I would run SQL Profiler to see if anything stands out. What protocol are you using? Does Performance Monitor show anything?Tara |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-08-13 : 17:48:57
|
| I am not sure what protocol means. Are you talking something in terms of TCPIP? I haven't looked at perf mon. i will now.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-13 : 17:54:32
|
| Well TCP/IP is one kind of protocol. There are others. If you are using TCP/IP, are you using the server name or IP address? Try pinging whichever you use to see how fast it is. It should be pretty fast considering it would be pinging itself. Is the application consuming too much memory and not allowing SQL Server to get what it needs? Or how about the reverse (is SQL Server consuming too much memory)? You can check this by checking the page faults on the individual processes. Bring up page faults for sqlservr.exe and the exe for the application. The number should be less than 10 on average. If SQL Server has more, then it needs more memory. If the application has more than 10, then it might need more memory but it also could mean problems with the application not related to this problem. Have you set the maximum memory option for SQL Server?Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-13 : 17:56:40
|
| BTW, you accidentally posted twice. Since no one has replied yet to the other one, I think that you can trash the thread still.Tara |
|
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-08-13 : 18:08:46
|
| Ok, we are using TCP/IP and I pinged to the server name , took hardly one minute. How do I get to page faults?**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-13 : 18:15:41
|
| I hope you mean one second for the ping. One minute is a very long time. Here is one of the replies I get when I ping my own machine: Reply from <Some IP address>: bytes=32 time<1ms TTL=128When I ping a server that is on the other side of the U.S. from me, I get this:Reply from <Some IP address>: bytes=32 time<87ms TTL=124In Performance Monitor, go to counter Process. Select both exes from the instance list. SQL Server is designed so that it doesn't page fault that often. So if you see page faulting a lot, it means SQL Server is starving for memory.Tara |
|
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-08-14 : 13:39:53
|
| Sorry I was in a hurry for my appt. Yes I did mean 1 sec not 1 min. I am pretty positive that is not sp3a which caused yesterday's thing. I found out that there was a huge rpt running simultaneously which I think caused record locking and the way PSoft services are work, sometimes when one process scheduler service which is running a process hangs, the other starts but doesnt recognize the first one is hung so we had 3 instances trying to run the same thing.But I am running perfmon now to understand the memory usage of server and application. I think i forgot how to interpret the graph so i am going to read that now. I don't know how to know if a pagesplit/sec is greater than 10. I was trying to look at the left 'Y' axis. Thank you so much for your guidance so far. If I ever meet you, I will treat you ;-)!Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-14 : 15:51:57
|
| For performance information related to SQL Server, see this site:[url]http://www.sql-server-performance.com/[/url]Tara |
|
|
|
|
Sp3 a connection issue?