118 reputation
5
bio website
location London, United Kingdom
age 36
visits member for 3 years, 5 months
seen Jul 24 at 16:51

DBA Divemaster Dad


Feb
10
awarded  Supporter
Mar
7
awarded  Autobiographer
Jul
5
comment Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory
sometimes its hard to know what facts to included. I was almost certain it wasn't the load and just looking for some possible thoughts on why the server would only use half the memory, but not throw an error. apologies if this wasn't enough but it may be more constructive for everyone to spend a little more time helping rather than attempting to tear strips off people.
Jul
5
comment Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory
the smaller db is a replicated with massively hit tables, for one reason or another a lot of these require scans, so i'd imagine virtually all of this would be in memory. That is just the small db, the larger db is not nearly as frequently hit but still requires a decent amount of memory, 1 hour after installing the memory is was using the max, 2 days later its only using half.. doesn't sound right
Jul
5
comment Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory
@TomTom thanks for the smart comment but the workload requires it, the server is used for 2 db's one being over 200GB, the other 52GB. Tempdb is heavily used by our APP Fabric configuration. I wouldn't have posted here if everything simply fitted into memory
Jul
5
comment Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory
I have a couple on there, 1 is 200GB the other is 52GB, the 52GB one is currently being heavily used and I also have been running REINDEX jobs overnight as well as data compression over most of th 200GB database so I'd be surprised if it only really needed 45GB max at all times
Jul
5
asked Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory
Jun
22
accepted OLTP Sql Server RAID configuration with 10 disks, allocation Unit and disk stripe size
Jun
22
asked OLTP Sql Server RAID configuration with 10 disks, allocation Unit and disk stripe size
Sep
28
awarded  Scholar
Sep
28
accepted SQL2008R2 Server access to XML templates in IIS7
Sep
23
answered SQL2008R2 Server access to XML templates in IIS7
Jul
22
awarded  Tumbleweed
Jul
13
answered Does 250 MB SQL Server 2008 R2 space enough?
Jun
8
comment SQL2008R2 Partitioning query
yes, all the normal maintenance, we have just upgraded the server, its 12 cores, 64bit 64GB of ram, but due to all these b****rd functions cant use more than 1 processor and is acting like a cursor as they reference other tables from the functions... needs to be written for sure, im just not the man for the job
Jun
8
asked SQL2008R2 Partitioning query
Apr
19
comment SQL2008R2 Server access to XML templates in IIS7
yeah the problem i had was upgrade advisor would not install on the Old machine, sayig that it needed a newer service pack. On the new server it cannot detect the older machine using the same windows admin login, I have checked the remote registry service is enabled, but no joy. We are not performing a full upgrade, just recreate replication to a new big reporting server, but nobody mentioned that there were .xml templates hanging off the back. Can I setup HTTP endpoints without having to rewrite any code ?
Apr
19
awarded  Student
Apr
19
asked SQL2008R2 Server access to XML templates in IIS7