SQL Server 2008 performance - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL Server 2008 performance

Author

Topic

bhavesh.darji
Starting Member

11 Posts

Posted - 2011-08-30 : 06:26:27

Hello friends,
We have a server which has installed following components.
1. Windows Server 2008 OS
2. 2 Quad Core processor
3. 16GB RAM
4. 1 TB hard disk

With above configuration when we run our application SQL server use RAM up to 12 GB to whole and releasing any memory.

What our application do, is receiving data from some entity continuously near around 150 packets per second and insert it to the database.

When i see the sqlserver in task manager it shows only near about 200MB memory usage, and if we restart sql server memory reaches to 3GB only from 12GB.

So what should be the issue with this??

Bhavesh

bhavesh.darji
Starting Member

11 Posts

Posted - 2011-08-30 : 08:16:47

Please guide if anyone can. Or give me link.

Bhavesh

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2011-08-30 : 08:56:34

That's how sqlserver works. It's trying to get as much memory as it can, for caching primarily to improve performance. It is supposed to do this.

Is this actually causing you a problem?

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2011-08-30 : 08:58:06

Also -- a quick google would have turned up about 1000 links for you to read.

http://lmgtfy.com/?q=sql+server+uses+all+memory

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

bhavesh.darji
Starting Member

11 Posts

Posted - 2011-08-30 : 09:20:45

Yes, that causing the problem. After reaching the above 12GB its giving the Timeout error for the query from application. And all the query becomes the slower.

Bhavesh

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2011-08-30 : 10:49:54

Is the application also running on the same box as sqlserver?

Are you maybe never committing?

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-08-30 : 11:26:54

If SQL is using too much memory, then limit it to a lower amount. That's what the max server memory setting is there for.

--
Gail Shaw
SQL Server MVP

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-30 : 11:29:44

I highly doubt that it is causing your timeout issues. What troubleshooting have you done to detect what's going on? Trace? PerfMon? Wait Stats? Out of date statistics? Index fragmentation? Blocking? I could go on and on.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

bhavesh.darji
Starting Member

11 Posts

Posted - 2011-08-31 : 05:42:08

Yes, My applications also running on the same server.

Charlie, we never used transaction for the queries. We just directly fire the query.

Now, i have reduce the max server memory for sql server.

Tara, i have seen the performance monitor and task manager to see the memory and performance. No other thing. If need to see any other kindly tell me.

Bhavesh

bhavesh.darji
Starting Member

11 Posts

Posted - 2011-09-02 : 03:14:06

Hey guys,

Please help me. I cant find the what is the actual problem is?

Bhavesh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources