MS SQL Server :: SQL 2005 Server Performance And Maximum Memory Pro

SQL 2005 Server Performance And Maximum Memory Property
A query was taking 20 seconds and consuming 70% CPU takes only 1 second after setting Maximum Memory property to 2048 MB - why?

Server:

OS Microsoft(R) Windows(R) Server 2003, Enterprise Edition

Version 5.2.3790 Service Pack 1 Build 3790

8 GB memory

Two Dual-core AMD Opteron 285 2.6GHz Processors

Server is not configured for AWE

Fiber channel connection to EMC Clarion - two LUNs - one for MDF, one for LDF

SQL 2005

SQL 2005 Standard Edition - SP1 (version 9.0.2047)

Three instances installed on server - only one instance in use

Binaries and system databases on local mirrored disk

Database file (MDF) on one EMC LUN - dedicated physical drives

Log file (LDF) on one EMC LUN - dedicated physical drives

Query in question:

SELECT TOP 10 Address.Address1, Address.Address2, Address.City, Address.County, Address.State, Address.ZIPCode, Address.Country, Client.Name,

Quote.Deleted, Client.PrimaryContact, Client.DBA, Client.Type, Quote.Status, Quote.LOB, Client.ClientID, Quote.QuoteID, Quote.PolicyNumber,

Quote.EffectiveDate, Quote.ExpirationDate, Quote.Description, Quote.Description2, Quote.DateModified, Quote.DateAccessed, Quote.CurrentPremium,

Quote.TransactionDate, Quote.CreationDate, Quote.Producer FROM ((Client INNER JOIN Address ON Client.ClientID = Address.ClientID) INNER JOIN Quote ON

Client.ClientID = Quote.ClientID) WHERE (Quote.Deleted = 0) AND ((Address.AddressType)='Mailing') ORDER BY Client.Name

Address table - 161,075 rows

Client table - 161,634 rows

Quote table - 59,145 rows

With default maximum memory setting (2,147,483,647 MB) - query runs in 20 seconds and consumes over 70 % of the CPU.

After changing maximum memory setting to 2048 MB, query runs in less than 1 second.

Question is:

What is the best practice for setting the minimum and maximum memory settings for SQL 2005?

What can be monitored to identify the cause of these type of issues - using profiler, PerfMon, other tool?

Thanks

View Replies !

Performance Issues Total Server Memory Vs Target Server Memory
Hi

I did a load testing and found the following observations:

1. The Memory:Pages/sec was crossing the limit beyond 20.

2. The Target Server Memory was always greater than Total Server Memory

Seeing the above data it seems to be memory pressure. But I found that AvailableMemory was always above 200 MB. Also Buffer Cache HitRatio was close to 99.99. What could be the reason for the above behavior?

View Replies !

Extreme Paging Rate Reduced By Setting &&"Maximum Server Memory&&" To 6 Gig?
We have several 2005 servers with "Maximum server memory" set to 214 gig, which I believe is the default at installation time. I am told that this means "use all the memory there is including paging." Well, this is nuts but the servers seem to work fine with this setting no matter how much physical memory they have.

One of our 2005 servers recently started paging like crazy, so I reduced "Maximum server memory" to 6000 and the paging disappeared (server has 8 gig of physical memory) and the server appears happy.

I can not explain why only this one server has this paging issue and the others do not. Should I be setting "Maximum server memory" on all my servers? Are there other considerations which might cause the server to eat-up all the memory? As far as I know no other applications run on this box.

Thanks,

Michael

View Replies !

Maximum Memory Problem
Hello, everyone:

I have SQL Server 2000 Standard Edition running on Windows 2000 Server. There are always memory full alter. I am going to configure that.

I hope a clearation about a concept. In my enviroment, does SQL Server take maximum memroy upto 2GB, no matter if QWE is enabled?

BOL said AWE is available only in the SQL Server 2000 Enterprise and Developer editions. Does it mean AWE cannot be configured on SQL Server 2000 Standard Edition?

Thanks

ZYT

View Replies !

Setting Maximum Memory
I need to up the Maximum Memory setting.

Out of the box it is set to 2147483647 MB.
I assume this is ~2GB. I have been instructed
to set it to 1GB less than total server memory
which is 16GB. When I change the value
it just changes back.

How do I change it and how are these Megabyte
numbers calculated?

OS: Windows 2003 R2 Enterprise
SQL: SQL Server 2005 Standard

Thanks!

View Replies !

Changing Maximum Memory Option
If I change the Maximum Memory option (sp_configure or vai EM), do I need to restart the MSSQL service?

Clive

View Replies !

Maximum Amount Of Memory Used For TempDB
I am trying to find a suitable size for TempDB in RAM .

Is it possible to find the instantaneous maximum usage of the TempDB in RAM?

In other words how can I find the maximum amount of memory used* by TempDB ?

bim@sifas.com.tr
mikiz@turk.net

View Replies !

Maximum Memory On Sql7 Standard Edition
Hello,
I have been trying to find out what the maximum memory we can have on SQL7 standard edition server. Have not been able to find it anywhere...
Anuy ideas would be greately appreciated.
TIA
B.

View Replies !

Sql Server Performance And Memory Usage
Hi All,

I'm new at SQL Server, I decided to use it in order to get all the advantages of using Vb.net and Sql. My server is a SQL standard version. I'm using a relational DB most of the time for complex select queries, everytime the server is used it performs 30 or 40 queries at the time, and I have recently realized that server consumes a lot of memory after one or two days of beign up.

Let's say that if I restart the SQL Server memory usage is about 650 Mb, but after two days memory is 1.4Mb, I have used Sql Profiler and Tunning Assistant where it recommended me to create some indexes, which indeed I created them, but that did not solved the memory problem, although some queries run faster.

My questions are:

is this memory usage is normal ?
if not, what should I check out to reduce memory usage?

Thanks in advance

George

View Replies !

SQL Server - Performance (Memory Issues)
Hi Experts,

here we are having a very very serious problem,

in SQL 2005, we are having 8 CPU's and in the task manager CPU usage is showing 100% and the performance of server is very very poor and last night the server has got rebooted, still CPU Usage is showing 100%, So how can i improve the performance? it is very very urgent for me, can any one please let me know what is going on and what is the solution.

-Thanks N Regards,
Kanthi.

View Replies !

Maximum # Of Rows In SQL Server Express 2005
Hi,

I have a DB running for a while, but it reached 32767 rows and stopped.. The DB is only 20MB big. Where can i ajdust this setting to a bigger number of rows?

thxs.

View Replies !

What Is Maximum No. Of Concurrent Logins Possible On A SQL Server 2005 Database?
what is maximum no. of concurrent Logins Possible on a SQL server 2005 Database?

View Replies !

Maximum Number Of Columns In A Sql Server Express 2005 Table
What is the maximum number of columns you can have in a sql server express 2005 table?

View Replies !

SQL7 Memory & Performance
Just two questions actually. We have built a ColdFusion based forums package. Currently we have it on two beta sites, and we are usin sql 7 for the db. Firstly the forums are serving 200-300 people at any given time, about 16,000 unique people a day. SQL & seems to stay at around 50% cpu usage on a dual p3 with 512mb ram. Is that normal? Seems like alot of cpu usage. The other thing is it takes 500mb of ram and just about drains the server of all of its ram even though in the memory properties for the sql server its set to 255mb maximum. Any insight is appreciated.

View Replies !

SQL CE Performance On Flash Memory
Hi,

I hope somebody here can help on my problem.
I wrote a MFC application using sql ce and is running prefectly smooth on wince and PPC 2003.
But when i deploy it to Windows Mobile, the database performance drop dramatically.
I knows the drop on performance is due to the I/O speed on the flash memory.(The previous mobile os are using ram instead).
Is there any solution or work around which I can solve this problem.

Recently i solved the performance issues on "insert" to DB by using a commit buffer(Instead of commit to the sdf instantly).
But how about the "select" performance? It's too slow which take about 3 sec to select a record from the DB.

Does Microsoft provide any suggestion on the sqlce perofrmance on windows mobile?

Thanks
Keith

View Replies !

Memory In Sql Server 2005
Hi

I would like to know how much of memory is taken by sql server 2005 entprise edition 64 bit during sql server startup in default configuration.....(4GB RAM being used).

i also want to know about montioring the performance of sql server 2005.Should i continue to use performance monitor (perfmon) or is there any new feature in slq server 2005 which provides performance monitoring.

Thanks in advance

View Replies !

Can't Get SQL Server 2005 To Use More Memory
Here'a a break down of what I've done so far.

* Windows 2003 32bit Enterprise with 10gb RAM
* SQL 2005 32bit Enterprise
* boot.ini - have added /3GB /PAE switches
* Confirmed which account SQL Server is running under and added that account to Local Policies/User Rights Assignment/Lock pages in memory
* Enabled AWE in SQL SERVER
* set minimum and maximum server memory to 9gb
* Rebooted.

Task manager says the following:
sqlservr.exe - 95MB usage * I know this is normal when using AWE right?
The actual physical memory used is 3.13GB and never goes higher. So this leads to believe that SQL is utilizing 3GB because of the /3GB switch, but it's not using the rest like it should be. I tried it without the /3GB switch and it only went up to about 2.1GB usage.

I've turned on performance monitor and SQL server target memory says 8.65 GB while the Total Server Memory says 2.45GB.

I've run:
EXEC sp_configure 'show advanced options'
RECONFIGURE
GO

EXEC sp_configure 'awe enabled'
RECONFIGURE
GO

And it confirms that the running value for both is 1

Please help.

View Replies !

Memory Problems && Package Performance
Hi,

I know the SSIS memory problem has probably been covered quite a bit, but being a newbie in using the SSIS, I'm not quite sure how to improved the performance of my SSIS package.

Basically, I've a package that loops through all the subdirectories within a specified directory, and it then loops through each file in the subdirectory and with the use of the Data Flow, process each file (according to their filenames) with a Script Component to insert data into a SQL DB.

Each subdirectory has up to 15 different csv files, but each is less than 5kB. I probably have about 100 subdirectories.

When I run the package, it functioned properly, but the package stalled (no error but just stuck in one Data Flow) after a while, and when I checked my CPU memory, it was running at 100%.

I'm not sure how I could fix it or improved the memory allocation. I was not expecting to have any memory problems as the file size is small and the number of rows of data going into and out of the Script Component is no more than 20.

Any advice? Thanks.

View Replies !

SSIS Performance And Memory Usage
Hi -

I am facing 2 problems :
PROBLEM 1 :
We have a few packages that run pretty fast on a desktop server with 2 Gig RAM, Dual processor (approx 4-5 hours). But the same packages run very very slow on the another server containing 8 CPU and 12 Gig RAM (ran for 24 hours without completing).

PROBLEM 2 :
The CPU% ranges from 40-80% and the PF usage is stagnant at 2GB on desktop server for the same package. But in the 8CPU server, the CPU % ranges from 0-10% but the PF Usage raises from 750 MB to 8 GB.

This has become critical to our application.

TIA,

Shabs

View Replies !

Memory Configurations For SQL Server 2005 EE X64 With SQL Server 2000 EE X32 On Windows Server EE X64 Server
My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed. We have SQL 2000 32-bit Enterprise installed in the default instance. AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings.

I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance. Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources. I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year. Any suggestions?

View Replies !

SQL Server 2005 Memory Management
Hi all,

I needed to load some tables in memory on startup because of performance reasons.
I'm using "select * from <table>", but there are few questions:

1. How to pin already selected data in memory ? (DBCC PINTABLE doesn't work for 2005)

2. How to put index data in memory ? (do you read document(s) for advance memory management - index data caching ?)

3. How to pin index data in memory ? (otherwise sound very bad - table data in fast memory, index data - in slow disks)

Thanks in advance:

Siol En

View Replies !

SQL Server 2005 Memory Management

Hi all,
I needed to load some tables in memory on startup because of performance reasons.
I'm using "select * from <table>", but there are few questions:
1. How to pin already selected data in memory ? (DBCC PINTABLE doesn't work for 2005)
2. How to put index data in memory ? (do you read document(s) for advance memory management - index data caching ?)
3. How to pin index data in memory ? (otherwise sound very bad - table data in fast memory, index data - in slow disks)

Thanks in advance:
Siol En

View Replies !

SQL Server 2005 Std Hogging Way Too Much Memory
Hi:

I'm running Windows Small Business Server 2003 Premium R2. I installed SQL Server 2005 Standard Edition on this PC. I'm using Std Edition instead of the Workgroup Edition that comes with SBS since I like the additional features in the Std Edition.

I'm a kind of a newbie to Windows Server administration and SQL Server administration although I've written lots of SQL queries, stored procedures, etc.

I have 2GB of RAM on this PC. When I looked in Task Manager, I saw that SQL Server was using somewhere over 1GB of RAM. So, I opened up SQL Management Studio, right clicked on the server node, clicked to get to the memory configuration page and saw that SQL Server was set to use all 2GB of RAM on the PC. I changed that to 500MB(500000000, or 476MB) and decided to reboot the server. When the server came back up, I forgot to check SQL Server's new RAM usage. The server ran without interruption for over 24 hours. Now, when I checked SQL Server's memory usage in Task Manager, I can see it's using over 750MB of RAM.

How do I fix this?

I have Exchange Server 2003 running on this PC as well.

Thx.

View Replies !

SQL Server 2005 DTS/Memory Usage
We have an application that we currently run on SQL Server 2000 that works by creating a DTS package that it then executes.

Due to performance reasons, we have been considering switching to 2005, for a few reasons. Can anyone confirm clarify the following?

1) SQL Server 2000 caps RAM usage at 2GB, whereas SQL Server 2005 is only limited by the OS - RAM usage is a big current issue for us, so if upgrading to 2005 would solve this it would help a lot. Can anyone confirm my understanding of this?
2) Would using the legacy DTS in SQL Server 2005 take advantage of this RAM difference, or is it running on the old 2000 engine and only able to use the 2GB?

Thanks for any help.

View Replies !

Variable Memory Utilization And Performance Considerations
Can someone point me to some good articles or perhaps directly supply some words of wisdom with regard to wise utilization of variables within a T-SQL script from and standpoint of conserving memory usage and improved execution cost?

For example:

(1) Is it better to use varchars, nvarchars, etc. defined with minimal lengths to support the needs of the script or is it just as efficient to declare all with a length of say 4,000?

(2) I've seen behavior that leads me to believe that when passing a variable as a parameter in a nested procedure call, if the declared types of the parameter and the variable being passed in don't match (i.e. one is numeric(38,10) and the other is int), then implicit type conversions hurt performance. Is this true and how broadly does it apply?

(3) Does the number of variables declared in a script materially impact the performance and / or resource utlization?

(4) Is it more efficient to have a series of variable value assignments in a single SELECT statement versus a series of SET statements? Should I always perfer one to the other? Only within a looping construct?

Thanks,

Shadowraven

View Replies !

Sqlservr.exe Memory Overflow And Performance Problem
Hello,

I'm havin a problem with my database server in the network, i'm running a windows 2003 server standard edition with sql server 2005 standard edition.

the problem is that the server get stock and the performance of the whole network is affected, when i use the tak manager to monitor the performance i can see that the sqlservr.exe proccess is using 1,397,928 k of memory usage, in the performance monitor the graphics get crazy and the cpu usage grows up untill 85%.

Can you please let me know if there is something that i can do to normalize the server performance in order to let the network user work with the applications feeded by this server.

Thanks in advance for your help.

View Replies !

Planning For SQL Server 2005: 64-bit, OS, Processor, Memory
I was browsing Microsoft's SQL Server site, looking forsome details about SQL Server 2005. Didn't find whatI was looking for...I'm thinking about moving an existing SQL Server 2000workload to a new box, using SQL Server 2005, andmaybe the 64-bit version.My questions are:1. What is the current target date for release of SQL Server 2005?Will 64-bit ship when 32-bit ships?2. Will 64-bit SQL Server 2005 require a special versionof Windows Server 2003 (e.g. Windows Server 2003 Enterprise x64)?Will it work with both Intel and AMD processors?3. How many CPUs, and how much memory, will be supported bySQL Server 2005, 32-bit and 64-bit, on each OS that can runSQL Server 2005.I'm looking for a chart here, something like the chart onpage 117 of Kalen Delaney's "Inside SQL Server 2000" book.SQL Server 2005 SQL Server 2005Feature Enterprise 32-bit Enterprise 64-bit------------------- ----------------- -----------------CPUs supportedWin Srvr 2003:Win Srvr 2003 Adv:Win Srvr 2003 Ent x64:Physical memorysupportedWin Srvr 2003:Win Srvr 2003 Adv:Win Srvr 2003 Ent x64:Has Microsoft published this info, and I just can find it?

View Replies !

What Is The Memory Footprint Of Enabling Clr In Sql Server 2005?
we wonder about the tradeoffs of t-sql vs clr in sql server 2005 especially from a memory perspective. Is there documentation available on this subject?

View Replies !

SQL Server 2005 Doesn't Allocate Available Memory
running Sql Server 2005 SP2 on Windows 2003 Server SP1 with 2GB RAM. After start-up, the sqlservr.exe does only take up around 100 MB of RAM, and it stays roughly there even if the DB is used heavily. This leads to very poor performance, even timeouts on simple querys.

In the task manager, I see that of the 2 GB of RAM, more than 1 GB is still available. I don't understand why SQL Server won't take it?

As a test, I configured the min and max amount of RAM SQL Server should used both to 1024 MB and restarted the service - but it is still the same picture. It won't take more than around 100 MB.

The server has just been restarted, but the problem remains.

BTW there is also an instance of SQL 2000 on the same machine. It shows the same behaviour - I even checked the "reserve phyiscal memory" checkbox there, but it stays on a very low number (50 MB) and doesn't adhere to the supposed size.

thanks and best regards,
- Urs

View Replies !

SQL Server 2005 Hogging Processor And Not Using Memory
Hi,

We have recently tested upgrading our web service from sql 2000 to 2005 sp1. The upgrade went smoothly enough, however we now have the problem of the sqlserver.exe process taking 90-100 % of the processors time, but using only 100 MB of memory.

We have 6GB available and we are running the enterprise editions of Windows 2003 and SQL 2005.

Machine specs,

DL380 G2, 2 X 2.8 Ghz Zeon, 6GB ram, Raid 5, database partition of 140 GB, Log partition of 35 GB.

Db is 25 GB, Log is 12 GB. Largest table has 32 million rows.

Any help would be greatly appreciated.

Rob

View Replies !

Memory Stress Test In SQL Server 2005
I have a Windows 2003 Server running SQL 2005. The server has 32 GB of memory and I have enabled AWE in SQL. I have also configured the min and max SQL memory as 1 GB and 28 GB, respectively. However, this server currently has very low activity so I'm not sure whether my AWE-related changes worked. SQLSERVR.EXE process takes up about 100 MB of memory. Is there any tool or scripts that I can use to memory stress SQL to confirm that AWE is really in effect ?

View Replies !

SQL Server 2005 Using All Memory After Installing Cumulative Update 5
Hi,

I have installed cumulative update 5 (version 3215) for SQL Server 2005 SP2, and now SQL service uses 120MB of memory according to task manager. but that's not all, after this install the PF usage went up to 7.5 GB, and now the server has about 400MB of available memory. How do I know this is SQL server? if I turn the service off, the available memory goes up to 7GB and the PF usage down to 500MB

It seems like SQL Server has reserved the whole memory as the process is using 120MB and not 7.5GB... as the PF shows.

The machine has 4 Opteron X2, 8GB of RAM. MS Windows 2003 Server R2 Enterprise, SQL Server AWE option ON

any help will be appreciated.

View Replies !

Memory Settings In SQL Server 2005 Standard Edition
Hi,

I'm having trouble finding the optimum memory settings for SQL Server 2005. I have 4 instances running on a macine with 8 dual-core processors and 18GB of RAM. I have tried the following memory settings so far:

No maximum - one instance used about 12GB of RAM so then the others struggled
Maximum of 4GB each (2GB left for Windows) - meant that 3 instances could be using 1GB each and then another at 4GB and needing more whilst 9GB sat unused.
Minimum of 2GB each - one instance would use up 10GB and then never give any back to the other instances.

I also find that setting a maximum then just causes a high amount of paging. What I would like to do is have each instance use a minimum amount, say 1GB, and then have each instance use a maximum of 13GB (3GB for other 3 instances running at a minimum level and 2GB for Windows). This 13GB should then be released and allocated to another instance when necessary, assuming it is no longer all being used. I do not want paging to occur if an instance reaches 13GB.

How do I go about configuring SQL Server to behave like this? Is it possible?

Thanks.

View Replies !

Memory Usage Of SQL Server 2005 Mobile Edition
Hi forum readers,

we are working on a release 2.0 mobile solution right now. In our version 1.0 we did not have to worry about memory issues as our application was the only application running on our target devices (e.g. T-Mobile MDA Compact II Pocket PCs, WM2005).
Now we need to share the available memory with others. As our application relies on its SQL Server 2005 Mobile Edition database we are wondering about memory usage of that server.

We know that a Pocket PC divides its memory into Storage and Program. If our application uses a 5 MB database and 1.5 MB for DLLs and it's exe-file. These files reside in the storage space when not loaded. When the application starts up it is loaded in the program memory. What happens to the 5 MB database file? Is is loaded into Program memory as well? Are only portions of that file loaded? Or is nothing loaded at all?

Does anyone have a deeper insight into that server an can answer my questions.

Best regards,
Tobias

View Replies !

Performance Problem, Lots Of Disk Activity, Running Out Of Memory
Fellas!!This is a very complicated one and it took me a few days to figure outexactly what's going on, but here's the final story:I have a production environment running on .NET with a SQL Server(2000, SP3). The SQL Server is on a dedicated Proliant computer with2GB RAM (the actual SQLServer.exe process has dynamic memoryassignment and can reach up to 1.6GB RAM). Nothing else is running onthat specific computer.Once the SQLServer is started, it hits 300MB RAM (the minimum that wasset in the configuration of the server - remember, it is dynamicallyaquired).Then there is a .NET program that requests just about all the data theSQL Server contains (apart from a single table that contains roughly1.6 million rows and another table that contains about 10000 rowswhich are all of type IMAGE).Once all the data is retrieved, the RAM is at about 400MB. From thereon, every update I make to the data on the server causes the RAM to goup by a bit (that updates are done in a Transaction which of course iscommitted at the end). It seems that BLOB updates are the majorproblem in all of this. For some reason, uploading a blob of size 9MBcauses the RAM to go up by roughly 20MB and after commit it gose down10MB (total gain of roughly 10MB RAM). Eventually the SQLServerprocess hits its upper limit (1.6GB) and at this point it startsslowing down.Some performance checks showed me the SQLServer has a lot of diskactivity, it seems it is reading and writing pages of data from/to theHD all the time (which causes the queries to be much much muchslower).We have a development environment running the exact same code (it isthe exact same in everything, except for the amount of data stored inthe DB). This does not happen there at all.I have a few questions:1. Why is the RAM going up after BLOB updates?2. Why is the RAM going up at all?3. How can I tell the DB which tables should remain in the RAM at alltime (never swapped back to the HD?) - DBCC PINTABLE does not seem todo the job.It does not seem to have anything to do with the .NET code.Thank you very much,M Yamo.

View Replies !

SQL Server 2005 Workgroup Edition In SBS 2003 R2 Max Memory Question
We have only a small busines and haven't got too much experience with servers and now have a proliant server coming in with SBS 2003 R2 Premium with the 4 GB max memory that SBS 2003 can handle according to the specs.

We weren't planning on using the SQL 2005 worlgroup edition up till now, but now we might. According to the specs of SQL server 2005 workgroup edition however, it has a max RAM of 3GB!

Is this going to be a problem and should we keep using our previous DB, or can we migrate toward SQL server with the 4 GB of RAM?

View Replies !

Setting Memory Values For SQL 2005 Standard (32 Bit) On Windows 2003 Server 64 Bit.
Hi,

I am testing SQL 2005 Standard (32 bit) on a Windows 2003 Server 64 bit with 8GB of RAM? Should I enable the AWP Setting or not and should I change the maximum server memory (currently saying 2GB)?

Thanks!
Tom

View Replies !

How To Make Use Of 4 GB Memory For SQL Server 2005 Standard + Windows 2003 Stardard
We just upgraded the memory of our database server from 2GB to 4GB. And its OS is windows 2003 standard and sql is 2005 standard edition. According to microsoft(http://msdn2.microsoft.com/en-us/library/ms143685.aspx and http://msdn2.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003), this configuration should allow database use up to 4 GB memory. My question is : Do I need to do anything(such as: adjust the maximum memory in management studio) to let our server be able to consume this extra 2 GB memory?

Does this solution http://support.microsoft.com/kb/274750 apply for SQL server 2005?

View Replies !

SQL SERVER EXPRESS BETA1 (2005) IS NOT RUNNING :SHARED MEMORY Provider Error
I'm facing several problems that I tryied to short out by msdn but could not get solution
I'm using visual studio .NET 2005 Beta(WHIDBEY),and
problem:1 sql server2005 Express edition is not running on My stand alone machine(AMD Athlon Xp 2000+,512 MB DDR Ram,CPU Clock speed 1.67 GHz)
Whenever I try to connect to SqlExpress using the server explorer in the VisualStudio.NET 2005 using follwing option in connection properties Dialog Box :
1.server name: the name of my computer(I'm using the Default Instance of SQLEXPRESS 2005) 2.Enter Information to log on to the server:usewindowsNt Integrated Security3.when I go to select the inuilt data base like masters it gives following Error message:-
"Shared memory provider:Specifed Module could not be Found"
problem:2In the process of making of Data Access component,I made an assembly named "TNB.DataLayer.CSharp.dll" and putted it at two place one in the ..in folder and another in the folder having the solution file .Now I want this asssenbly to put in Global Assembly cache so that parts of my project (a window Application and a Web Application) can access the database using this TNB.DataLayer.CSharp.dll Now i need to make my assembly a strong name so I used following at the .NET command Prompt sn.exe -k TNBKeyPair.snkand put this file in the folder where My solotion .sln file exist.now as I have the keypair file,I tryied to sign the assembly TNB.DataLayer.CSharp.dll with this key for this when I added the following in to the AssemblyInfo.cs file[assembly: AssemblyKeyFileAttribute("TNBKeyPair.snk")]
warning on bulding the solution is
Warning 1: Use command line option '/keyfile' or appropriate project settings instead of 'AssemblyKeyFileAttribute' D:gopaldot net newTNBTNBPropertiesAssemblyInfo.cs 19 11
and when I use the /keyfile:TNBKeyfile at the command prompt I got another Error message:The file name, directory name, or volume lable syntax is incorrect.
and finally I'm not able to sign the Dll and to put it in global assembly to use from different envioronments.
so please help me in solving this problem.

Thanks!
ur faithfully

View Replies !

SQL Server 2005 Service Broker - Activation Stored Procedure Memory Usuage
We are looking for some guidance with an issue we have picked up with our implementation of Service Broker here on the ABSA Capital project and I am hoping you can help or point us in the direction of someone.

The architecture we have implemented for service broker is to make use of an Activation stored procedure on two queues (1 SP per queue) to process the messages received. What we have found is that the activation stored procedure runs on a background session and its CPU time and memory just grows to the point where it brought one of our UAT servers to a grinding halt.

Is there anyway we can reduce the memory consumption of the activation stored procedure or is this one of those things that still need to be ironed out in Service Broker?

View Replies !

Maximum Database In An SQL 2005 Intance
Hi I would like to know, what is the maximum number of database that you can create in one SQL 2005 Instance?

View Replies !

Maximum SQL 2005 Database Size

Hello! I'm trying to figure out what the ultimate size limitation for a SQL 2005 Enterprise server is. This document is helpful but I'm a bit confused:

http://msdn2.microsoft.com/en-us/library/ms143432.aspx

In the document, it says that the maximum database size is 524,258 terabytes; however, it also says that the maximum data file size--which I assume is the .MDF file--is 16 terabytes. My question is, how can you create a 524,258 TB database if the maximum file size 16 TB?

Dumb question, I'm sure...please enlighten me!

Norm

View Replies !

SQL Server 2005 Performance
Hello!I have a very simple structured table:id | datawhere "data" is a varchar(100) This table would contain a lot rows (~ 500.000.000) and I want to select all "id" where data=@data. Is it realistic that the SQL Server could serve this request on a normal webserver within 1 or 2 seconds? Thanks!

View Replies !

SQL Server 2005 Performance
I have recently upgraded from SQL Server 2000 to SQL Server 2005, and now all my queries run infinitely more slowly.

Here is the scenario - I run an extract of a MS SQL Server database at a client site, then recreate the database on our in-house server - but without indexes etc. Then I run various queries in order to created data files that will be used for importing into a global system. When I was running Server 2000, most of the queries ran in less than 10 seconds each, but under Server 2005 they take 3 minutes or more! Does anybody know of any parameters that I need to adjust to fix this problem?

View Replies !

SQL Server 2005 Performance
Hi..

i have just migrate my sql server 7 database to sql server 2005. but i have follwing problem.. " user access the database rather slow it takes 2-3 minutes to appears, even when click command button "save"or "confirm" they are also takes 2-3 minutes to show confirmation button.

My database only 9 gig .. is it normal ?access by 30 users

otherwise my server win2003 , using Pentium xeon , IBM 266 series, with 2 gig RAM, 80 gig HDD x 2 .

please advise what should i do ?

note : Auto create/update statics is True, Auto update statics async. is False.

View Replies !

Maximum Number Of Databases Used For Each Query In 2005?
In MS Sql Server 2000, if you run a stored procedure that query's morethan 8 databases, you get this error gets raised:Maximum number of databases used for each query has been exceeded. Themaximum allowed is 8.In 2005, does this maximum number still exist? if so, is it still 8, orhas the number been increased?Thanks,Mike

View Replies !

What Is The Maximum Number Of Sched Subscriptions In RS 2005?
hi,

is there a limit for number of Subscriptions per report? per folder? per RS 2005 service?

thanks

rafi

View Replies !

Microsoft SQL Server 2005 Performance
Hi,I have a Microsoft SQL Server 2005 Enterprise installed on Windows Server 2003, and developing web application for 500 clients. So I am interested will I have any performance issues if I put in 'Articles' table, data for all 500 clients and then filter it on client ID, or should I make 500 'Articles' tables for every client one with different name and then change sqldatasource for gridview depending on which client is working on it. I will have, beside 'Articles' table, another 10 tables, which means 5500 tables total, if I use second approach, on first I will have only 11 tables. So I am asking is it better to have more tables with less data, or less tables with more data. And what are pros and cons for both approach. Thanks a lot!

View Replies !

SQL Server 2005 Performance Issue
Hi

I'm not sure I chose the right forum, so any comments on that are also welcome

We recently changed from SQLserver2000 to SQLserver 2005 in the beginnen all went fine.
But now we are struggling with a severe performance problem...
suddenly SQLserver2005 reaches its max and is not longer able to work properly -> Extremely slow

I'm wondering if there are other people / companies / ... sharing this same issue?

Thanks for time and effort

Kind regards
Wimpos

View Replies !