Speed, Memory Usage Question For Photo Management
Hi all, quick question. A while back I developed a website that allowed upload of photos. At the time, I used ASP and VBasic-behind and wrote code to store and retrieve all photos in an SQL database in binary format. I am looking at a new project, very similar, and was wondering if anybody had any idea how this method might compare to simply storing the image files on the server and using the database to simply point to their location. I am wondering how the two methods compare spped wise and hard drive space they may consume. Does anybody have any idea on a direct comparison?? Any benchmark tests anybody has seen or ran?
Thanks all,
Chris
View Complete Forum Thread with Replies
Related Forum Messages:
Memory Leak...How To Get Memory Usage For Each Connections?
Hi Guys,I find there is memory leak in our SQL 2000+SP3 databass. We have aclient-server system, and the there are Jrun4.0 running JSP and someotherJava application talks to the database.However, for only less than 40 users, the SQL 2000 memory usage willincrease consistantly until it use all the memory it can get ,about 1.7Gmemory. Then eventually the SQL server process will hang in couple days.I don't know whether JRun JSP stuff or Java application is the culprit, andI am wondering if there is a way to monitor the memory usage of everydatabase connection.I would love to know what you guys think!Thanks a lot!
View Replies !
Too Much Memory Usage
Good day to all, I'm new here, so I don't know if this is the right forum to post my problem. I have a web application written using C# .net 2005 (W/ajax). The application has a module that uploads data from excel file to the sql server 2005 database. w/c is by the way, i'm using SQL 2005 Express Edition, the app can upload up to more than 10,000 records from an excel file. Everything is ok until it was deployed in a test environment, while having a run through with the system, the application encounter an error after which, we cannot log in to the system anymore. I restarted the server (web and sql server in 1 machine running winxp) then I can log-in again in the system. When I'm tracing where the problem came from, I noticed that the memory usage of sqlservr.exe increases everytime the app connects to the server. I already fix some code to close some objects that might have caused the high memory usage, then I run sp_who in the management studio and there are still connections used by the app AWAITING COMMAND. Then I manually kill (using kill spid) connection that are left opened by the application. But the mem usage of sqlservr did no decrease. Is there a way to release the memory usage of sqlservr.exe? In ASP.Net ? I have a hint that this has been causing the error. Thanks a lot.
View Replies !
Getting Memory Usage Through T-SQL
I'm trying to get the machine free ram value using either T-SQL orSQL-DMO.I found .Registry.PhysicalMemory which takes care of the total ram butI still need eithrt the free or the used.Any ideas?Thanks!
View Replies !
Memory Usage
I was on my friend's server earlier and I checked his system stats. Between sqlservr.exe and msftesql.exe he was using 2.9gb of ram. This is not a high traffic server so I felt that was just a wee bit high. What are some usage experiences you have seen? I have not worked with 2005 so I don't know what the usage should be like for a low to medium usage server. The guy that admins the db is kinda a moron anyway. He said he has said to the server admin it has been optimized, but I dont believe it one bit at 2.9gb of usage. Any comments would help. Pete
View Replies !
Memory Usage
Hello, I need to know which of the following two methods do need less RAM. There are 2 big tables, each about 9 M rows, and 6 small dimension tables with each about 10 to 100 Rows. The dimension tables are joined by their id's with one of the big table. The Structure of a dimension Table looks like CarID (tinyint), Description (varchar(20)) 1 BMW 2 Porsche I want to join the 2 Big Tables in a materialized view. Later i will run queries like select * into #temp from dbo.vw_materialized_view where Car = 'BMW' So, back to my question, will such a query take less memory (ram) when i joined all 8 tables before I created the mat. view or will it take less when I only join the 2 big tables in a mat.view and later join the mat.view with the 6 dimension tables? Hope you got that ;-) Thank you
View Replies !
CPU And MEMORY Usage
Can some one tell me where can I get the CPU and Memory Usage of my server on the Sql Tables or a script or store proc that i could run to get the above. I need that and to store its results in history to show how are our servers perfoming
View Replies !
Memory Usage.
Hi, it seems that every day SQL Server 2000 has some kind of memory leak, the memory usage creeps above 150000 approximately 3 times per day. Is this normal? It starts at about 13000. Is there any way that I can monitor what is causing the memory usage to be so high and maybe rectify it? Thanks for the help. Steve
View Replies !
CLR Memory Usage
Hi All - We have some CLR sprocs and tvf's we run in a batch job that recently have been getting the out of memory issue. I want to increase the amount of memory allocated to the CLR using the -g startup switch but i want to make an intelligent decision on how much to allocate. What are some of the best ways that you have found to estimate how much to give the CLR? Thanks, Cameron
View Replies !
Memory Usage
Not sure if this is the right forum, but here goes. We have a multistep SQL agent job that executes various data load / conversion SSIS packages. Most of the steps consist of simple script tasks. The agent job processes the Analysis Services database at the end. All cubes are MOLAP type. Our hardware is as follows: DEV €“ Single 3 Ghz Xeon with 2 GB RAM. Windows Server 2003 Standard SP1. SQL Server 2005 Standard Database, Analysis Services, and SSIS. PROD €“ Dual 3.6 Ghz Xeon with 4 GB RAM. Windows Server 2003 Standard R2. SQL Server 2005 Standard Database, Analysis Services, and SSIS. Both servers have the same SQL Server and Analysis Services Databases. Both servers use the same input files when running the agent job. The input files are located on another server and the biggest file is a 75 MB txt file. The agent job failed yesterday on the DEV Server while processing one of the SSIS data load steps. I checked the logs, but could not find any meaningful error. The only thing I noticed was that the server€™s memory was up to 2 GB and the server was responding sluggishly. I tried rerunning the job two more times, but they also failed during the data load step. I ran the same agent job on the PROD Server and it completed as it normally does in about 15 minutes. I reran the agent job on the DEV Server this morning without a problem. I know that the DEV Server was rebooted last night because they applied the July Microsoft patches to the development servers. When the agent job is run on the PROD Server, the SQL Server task take up about 1,700,000K of memory and barely budges during the duration of the job. Analysis Servers usually starts out around 290,000K and gets as high as 1,000,000K. But it always retreats back to about 700,000K when it reaches 1 GB. When the agent job is run on the DEV server, the SQL Server task gives up memory to Analysis services and the total memory allocation does not seem to exceed the physical amount available. Does anyone have any insight on what I am experiencing (memory wise)? Any suggestions on what I could've done yesterday to determine why the job failed? Why doesn€™t Analysis Services use more that 1 GB memory on the PROD Server? Is there an automated process that we can run prior to running the agent job to reduce the allocated memory? Right now, the agent job only fails on the DEV Server but we don€™t want this to become an issue on the PROD Server. Thanks!
View Replies !
How Much Available Memory And PF Usage?
How much available memory is best practice for SQL servers? We have some alerts set up by our system admin, they go off if the available memory goes below 500mb. Which is fine for other servers but I feel for SQL server it isn't quite correct. Currently we stand below at about 475mb and the PF usage is around 7gb. It is SQL 2005 standard SP1 x64 dual intel xeon 5160s 8gb physical memory buffer hit cache is > 99% I am just not confident enough to make a solid decision here that this is acceptable. In the beginning of this month I ran some counters for 24hrs to get a feel for the baseline. The average for available memory was about 850mb at that time. So I am wondering if it is going to keep declining and turn into a problem. The server/instance has not been restarted since maybe last November. thanks
View Replies !
SQL Memory Usage
Hello, I have SQL Server 2005 64 bit on Windows Server 2003 Enterprise 64 bit on a server with 8GB of RAM Task Manager reports the process sqlserver.exe consuming 7GB of memory Is this normal ?
View Replies !
X64 Memory Usage
I have setup 2 x64 SQL boxes now that are having problems with memory. Both boxes were pretty much setup with the defaults on windows 2003 R2 64 bit server, only changes were file locations etc. On both servers the memory usage continues to climb over the course of a few days until all physical and virtual memory is used and the server comes to it's knees. A reboot will stabilize it for a few days while the memory usage ramps up again. The sqlservr.exe process does not report much memory but the commit charge in the performance tab of task manager shows the maxed out value. I thought the sqlservr.exe process only didn't report the correct memory figure when AWE is enabled which it isn't. I thought as a default, SQL server would dynamically allocate memory as needed and had internal mechanisms that would not use more than the physical ram available. The one server has 16GB and I even set the max SQL memory usage to 12GB but still my total memory usage would get out of hand. SQL Server is the only application on these boxes. Am I making some incorrect assumptions and need to change the way SQL is setup? Any suggestions? Thanks Scott
View Replies !
Memory Usage
how to check the memory usage other than performance monitor for the server? When I execute the SP_WHO2 on the server, it showing each user have 5 connections there and the status is sleep. what is that means? Does it takes up memory? why have so many connection or entries for the same user, they all are using the same db with same application. Thanks!
View Replies !
Memory Usage In SQL Server
Hello all,How can I tell how much memory SQL Server is using on a server. OnWindows 2000, whenever I go to Task manager/processes/memory usage SQLServer seems to be showing 1,744,124K. On all of my servers withvarious size, usage of databases, all of them show SQL Server to beusing about the same amount of memory. Can someone explain this to me?Shouldn't it use more for larger databases, heavy hitting databases?Also, I normally check Dynamically configure SQL Server memory and putthe maximum threshold to a little bit less than the max on the server.The minimum query memory is set to 1024. Is that 1024 a subset of thememory used by SQL Server, or is this additional that can be used?Thanks,Raziq.*** Sent via Developersdex http://www.developersdex.com ***
View Replies !
Sqlservr.exe Memory Usage
Hello All,On all of my SQL servers (2000 with SP3), when I go to task manager andlook at memory usage, sqlservr.exe is always at 1.7gigs. If I reducethe maximum to let's say 1 gig it will go down to 1 gig. But if it iseven at 2gigs or 3 gigs it will be showing 1.7 gigs. Why? Is is ok toreduce the memory usage of sqlservr.exe?Raziq.*** Sent via Developersdex http://www.developersdex.com ***
View Replies !
Monitoring Memory Usage
Hi guys,I am considering upgrading memory in my MS SQL server cluster from 8GBto 16GB on each cluster node. I was wondering, whether you could suggesthow to measure the overall performance gain after the upgrade.Basically, I would like to estimate performance/cost ratio in 8GB, 16GBand possibly 24GB configuration. The cluster consists of 5 Windows 2003enterprise servers R2 with SQL Server 2005 (the 64 bit edition) on each.Thanks
View Replies !
Memory Usage - Max Setting
I am using SQL 8 Personal edition with sp2 applied. I set the maxserver memory to 32MB and leave the min server memory at 0. When myapplication starts hitting the database hard the memory usage reportedthrough task manager peaks between 41-42MB. I've stopped and restartedthe MSSQLserver service and checked that the running values are what Iset them to be. Does anybody have any ideas as to why the sqlservr.exewould be utilizing more memory than the configured value?This message was posted some years ago but nobody answered. Now I havethe same problem! Does anybody have an explanation?Thanks a lot
View Replies !
Session Memory Usage
Hi,does someone know how much memory a user session takes on a SQLServerdatabase server? How many concurrent user sessions can a normal server(4 GB primary memory) handle, before connection pooling is needed?/Fredrik
View Replies !
SQL Server Memory Usage
Hi All, Currently I have an application that uses SQL 2000. The SQL server service tends to take up as much of the physical memory as possible. The problem is I also have other services relating to this application running that are very important. What tends to happen after a period of time is SQL takes up all of the physical memory, so that the other services are using the paging file (virtual memory). This causes extremely slow response time over the network as these other services are having to parse the paging file. Upgrading the memory is currently not an option :( I know there is an option to set memory usage for SQL but I am unsure how this would respond in a production environment. What would happen if SQL would require more memory than what was allocated to it? Can SQL release the memory and still act as normal? Any input would be generously appreciated Cheers!
View Replies !
SQL Server - Memory Usage
I am using SQL Server 7.0 on a Windows NT machine. We have been having problems with SQL Server not releasing the memory after it has utilized it. Currently it is configured to allow a max of 511MB memory (1024 is total on the machine). I had some advice that my best solution would be to reduce the Max Memory to a lower value (say 400 MB) to help reduce the problem. Is this not counter-intuitive? Or is this the correct solution? Thanks.
View Replies !
SQL 2000 Memory Usage
Our production server has 3.3GB of memory and is running Windows 2000 server(service pack 2) and SQL 2000 Standard Edition(service pack 1). We have configured SQL to use the maximum memory for standard edition (2GB) In use, however, task manager shows SQL is only using 1.75GB maximum memory Our database size is 11Gb and we wouldexpect to see SQL using the full 2GB I have heard a similiar story from a colleague at another installation.. Does anyone have any insight into why this would be the case?
View Replies !
Memory Usage For Sql Server
Hi, One of the production box running only sql server application, is showing 80% memory usage on the task manager-memory usage history right now. We are running sql server 2000 standard version-sp3 with 2GB memory on this box. Server is not on the scheduled reboot at this point. We have seen this behavior for this box last month that after task manager showing 90% memory usage contantly for several days, when server was manually rebooted, memory usage dropped to 35%. Now it's back to 80%. Our DBA thinks that server should be rebooted on a regular schedule regardless of memory problem. Our network admin doesn't seem to agree with this. He is not ready to reboot the machine even with this high memory usage. There is no noticable difference performancewise yet. My questions are: Is it bad that memory usage reaches from 35% constant to 80-90% or is it common? Should sql server be rebooted immediately to take care of it? Should sql server 2000 rebooted on regular basis regardless of any problems? Shouldn't sql server be releasing memory back to the OS even without rebooting? How do I find out whether server actually is going through memory problems and what is causing it? Thanks in advance for your opinions, Shaili
View Replies !
SQL Memory Usage High
hi all I got a small MSSQL server.. total database file size less than 7GB. with 2G rams installed 2 cpus. but for some reason when i check the task manager process mem usage is over 1.7G. the sql server memory setting in on Dynamically not fixed. and maximum 2G i believe is default. anyway. my question is over 1.7 memory usage is too high? because i dont have alot of transaction going. and cpu usage is very low. wondering if this's normal or not. and if is not normal . what cause the memory usage so high...... and how can i adjust back to normal. ? can anyone help me out? or any suggestion? thanks
View Replies !
Huge Memory Usage With BCP?
Does anybody know why BCP on v6.5 grabs so much memory for SQL Server? I have a few table imports where the BCP process will consume over 460MB of RAM during the imports. The BCP cmd file is executed via an xp_cmdshell call. The server has 2+GB of RAM, but the BCP process effectively flushes large amounts of data from the buffer. It takes quite along time for the cache to recover from this, and after this, the rest of the nightly processes run much slower, as they end up having to hit the drives to retrieve information that should already be in cache. If anyone can shed some light on this it would be much appreciated. Ian Dundas DBA Assante Asset Management
View Replies !
Memory Usage SQL2k5
So I was on my friends server this afternoon, and I pulled up the task manager, 3270 out of 3963mb was used in ram. 1.6gb was physical/virtual for sqlservr.exe and another 1.3 for msftesql.exe. The guy that maintains them is kinda an idiot so my thought are that he does not have SQL Server configured right. He said he had done all he could to optimize memory, but if both of those applications are 2k5, there is no way. Can someone tell me what kind of memory usage they have experienced with a 2k5 instance running on medium usage sites.
View Replies !
Memory Usage Of SQL Server Ce
Hi, I'm wondering about the memory usage of SQL Server Ce and the Compact Framework. I've heard I can use only 32 MB per process. SQL Server Ce runs in process and my database file is about 60 MB big. 1. Does that means, I can only use for my application: 32 MB - CLR - SQL-Server Runtime - parts of my database file hold in memory 2. Is SQL Server Ce swapping parts of my database file into my process memory? If so, is there a chance to group some tables, that they are swapped together to increase performance? 3. Means big databases big memory usage in my process memory? Thanks, Stefan
View Replies !
SQL Memory Usage Problem
Hi to all, I front a series problem with my SQL Server. I Use SQL Server 2000 standard on Windows 2000 Server machine. The problem: after certain actions such as DTS (that takes table contents and insert to a a file) the Memory usage of SQLservr.exe is grown significantly and after it finshes with success it doesn't free the used memory for the action - in this case the DTS. maybe this explains why I have Memeory Usage of 1700MB of Sqlservr.exe on windows task manager. Is it a bug? why SQL doesn't free the memory after finishing the action. Any Solutions ? Please send me a short feedback. Roy
View Replies !
Excessive Memory Usage
Hi there group. Could some please point me in the right direction? We have a database and it's about 28GB in size, recently the SQL server process that runs uses approximately 1.6GB of Memory. I have tried running SQL profiler to find out which Stored Procedure is causing this but came up unsuccessful. When restarting SQL the process it run's at about 50MB for about 20sec and then starts climbing up to 1.6GB of memory usage. Please assist.
View Replies !
Sqlserv.exe Memory Usage
With SQL Server 2005, I have the problem that sqlserv.exe keeps using more and more memory. Now I did some research and found the following anwers in different places: *It seems to be the way that SQL Server works. It just uses all the memory which it can get. I have two remarks about this: 1) I that is true, then why is a fresh installation of SQL Server not consuming all the memory it can get? 2) After a few weeks, it consumes so much memory that the whole system (even SQL Server itself) start running very slow. I don't think that's the intended behavior? So I thought about restricting the maximum memory that SQL Server uses, but people keep saying that's not the way it should be done: SQL Server should be allowed to allocate memory dynamically. Can anyone help me with my questions? One other thing that may be of relevance: This instance is a disitributor for replication and the distribution.MDF file also seems to be increasing over time. It became much larger than the application database. Thanks in advance for replies
View Replies !
Process Memory Usage
I am using a tool to monitor SQL Server and Windows. It is warning me that: Process 1004:services has a virtual address space of 1,846.20 MB. This is close to the Windows two gigabyte address space limit. When locate the process 1004, it shows 15 threads that Elapsed time for all of them is 1d, 3hrs. The Thread state is Waiting and the Thread Wait Reason is "Waiting for an Execution Delay to be resolved". I think that 1d, 3hrs is from the time I rebooted my server. Should I take any action? How?
View Replies !
Memory Management (fixed Memory, AWE)
Hi, I am going to install SQL Server 2000 (then SQL 2K5) on a Win Server 2K3 with 8 GB of ram, but it will be 16 GB in the near future. I would like to reserve a fixed memory (for momemt less than 3-4 GB) for SQL Server and the rest for application (virtualization). Without AWE enabled, max memory for SQL Server 2K5 is 4GB as for SQL Server 2000? How can I manage and optimize memory keeping in mind AWE. (any doc, website available?) Thank
View Replies !
Cluster /AWE / 3GB Switch /Memory Usage
Dear all,i am planing to implement a Windows 2003 Cluster with MS SQl 2000Enterprise Edition. I have 2 Nodes (4 * XEON MP Processors) with 8 GBRAM per Node.I have the need for 6 SQL instances and would like to implement aactive-active cluster. What do you think it the best way to configurethe memory for the Servers ?I would like to run 3 instanced per Node but can i allocate 7 GB perNode for SQL (and 1 for the Operating System) ?What is happening then i one server fails ?Should i plan to allocate only 3 GB per Server for SQL to make surethat one server can handle the load for all instances if one serverfails ?Should i use the /AWE switch only in the boot.ini to allow more than 4GB Memory ?or should i use the /3 GB switch as well ?Maybe somebody can give me a hint.Best regards,Walter
View Replies !
SQL Server Process And Memory Usage
Hi AllSome my SQL Server are experience high memory usage.1. How can I detect which process which process cause the big memoryusage and not released?2. Which sql server components in this memory, and what are their usagedistribution?Any help will be appreciated.ThanksWillie
View Replies !
Why The Memory Usage Of SqlServer Doesn't Go Down
Hi Gurus,Our system is using SqlServer 2005 on XP.( On my machine,only thisapplication access SQLServer.) The sqlserver memory is configured to128MB (Min)~512 MB(Max)After our system get started, sqlserver takes about 100M memory. Afterthe system runs for a while, the memory used by sqlserver goes up to512MB. Then we exit our application and expect the memory usage ofSqlServer could be dropped down to the min value. Unfortunately, itseems SqlServer never release any memory until we restart it.I thought dynamic memory configuration means that SQLServer can autoshrink memory usage if there is no more database accessing. But basedon my observation, SQLserver just holds all the memory . :( How canwe let the sqlServer shrink the memory usage accordingly to workload?I do appreciate for your help!Best regards,Jennifer
View Replies !
Win2003 / Sql2000 Memory Usage
I have googled by heart out trying to find answers to this and am onlymore confused.DB Server:Windows Server 2003 Enterprise4 GB memorySQL Server 2000 Enterprise Edition, SP4 8.00.2039The SQL server process appears to be using a steady 1.7 gb of memory.There are no other memory intensive applications running on thisserver as reported by Task Manager.I have read all about the 2gb/process limit and the /3gb boot switchand all but most of that seems to apply to windows 2000, not 2003. I'dlike SQLServer to use more of the memory if it can (assuming it wouldbe advantageous for performance).Can anyone sum this up for me?Thanks,Michael
View Replies !
Memory Usage In Task Manager
Hallo, I am a newbie on SQL server and my problem is this: My SQL server runs with many client queries and after a while I can observe that the meory usage of the SQL server shown in the Windows Task Manager is growing up (e.g. 260 MB !!!). I checked the online books and found the settings "min/max server memory" which I set to min = 4 MB max = 20 MB by Enterprise manager. Then I restarted my SQL server, checked the memory settings again by Enterprise manager and started many client queries. The memory usage in Task Manager nevertheless exeeded the 20 MB. What is my failure? How can I limit the memory usage of SQL server? Thank you very much for any help...
View Replies !
Sqlserver.exe Memory Usage Increasing
Would anyone have any suggestions/advice on how to determine what is causing the memory usage for sqlserver.exe to increase a dramatic pace in windows task manager? What would be a good resolution to slow down this memory usage? Thanks!
View Replies !
Increasing Memory Usage On SQL Server
Hi all, Our Production server has 4GB RAM and is running SQL Server 7.0. By default since SQL Server 7.0 Standard Edition can take up only less than 2GB, our SQL Server is now using only 1.8GB (leaving the rest for the OS, Windows 2000 Server). Inorder for SQL Server to take advantage of more than 2GB of RAM it is suggested that boot.ini be modified to include the switch, /3GB Has anyone seen any issues with doing this? Is it safe to do so on the Standard Edition of SQL Server 7.0? Thanks in advance, Praveena
View Replies !
MS SQL 2005 && Memory Usage Question
OVERVIEW I run a MS SQL DB and have 7GB of RAM allocated to it to use. My DB size is around 30GB. I have about 30-40 users at any given time accessing this DB, and on any given moment we may have 2-3 queries being processed at the exact same time, but not really a high rate of usage. The SQL is running on a 2 - Dual Core Xeon 2.8Ghz processor server in RAID 1+0. The average CPU usage is around 8-15% at most times, spikes to 60-70% sometimes then drops back down. QUESTION Why or what would cause SQL to show in my Task Manager as using 7GB of RAM constantly? When I restart SQL, system RAM drops to 1.7GB and holds. As traffic increases, as queries begin to be processed in SQL the RAM rises till it reaches the 7GB limit I set. Before it reaches this limit, the ASPX pages run smooth as silk. Once it reaches this 7GB limit they begin to crawl. A process that would take 2-6 seconds, now takes 30-60 seconds. I know a couple years back I ran into this and it was because processes were not being closed and SQL was holding them in RAM, but I have been assured this is not the case now. I was told that because my DB is 30GB total (MANY tables, most are hardly ever accessed, and the bulk of the data is hardly accessed) that it is common for SQL to use and hold on to 7GB of data - is this true? What would cause SQL to hold 7GB and slow way down? IS there a KB article that could help me understand this? Thanks for your help.
View Replies !
Control/Limit Memory Usage
Hello, I was wondering if there was a setting or a way to limit or restrict the amount of Memory an SSIS package can use? I know that by default the windows OS limits a process (a package in this case) to 2GB and up to 3GB with AWE enable but what if I wanted to say Limit it to 1GB of memory is there anyway to do that? Is there an SSIS Engine setting or Package property somewhere? Thanks!
View Replies !
|
TRACKER
