Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > thread for when you have computer problems
 
  • Post
  • Reply
Squinty Applebottom
Jan 1, 2013

 iOS 8 adds text messages to iMessage app

* # ¿ Jul 22, 2014 00:07
  • Quote
Adbot
ADBOT LOVES YOU

# ¿ Apr 28, 2024 12:48
  • Quote
Squinty Applebottom
Jan 1, 2013

 I'm sorry i don't have any of the answers your looking for

* # ¿ Jul 22, 2014 00:09
  • Quote
Squinty Applebottom
Jan 1, 2013

CISADMIN PRIVILEGE posted:

running this query should tell me the physical memory that an SQL server has available right?
code:
select * from sys.dm_os_sys_memory
total_physical_memory_kb	available_physical_memory_kb	total_page_file_kb	available_page_file_kb	system_cache_kb	kernel_paged_pool_kb	kernel_nonpaged_pool_kb	system_high_memory_signal_state	system_low_memory_signal_state	system_memory_state_desc
4182924	867476	8612588	5560336	1417072	135928	62548	1	0	Available physical memory is high
I'm running it on a hosted server and it gives 4 gigs which seems shamefully low.

If I run

code:
SELECT object_name, counter_name, cntr_value AS 'Total Server Memory (KB)'
FROM sys.dm_os_performance_counters 
WHERE counter_name = 'Total Server Memory (KB)'
I get 1638272 KB which for a sql server with probably 50 people connected to it, and 20 gigs of actively used databases seems so low that it shouldn't even work.

is that total server memory or memory allocated to the instance you're connected to?

also lol @ 20 gigs of databases. thats adorable.

* # ¿ Jul 22, 2014 18:37
  • Quote
Squinty Applebottom
Jan 1, 2013

 second one will definitely be total server memory. 16 gigs is probably overkill for your tiny baby database.

* # ¿ Jul 22, 2014 18:38
  • Quote
Squinty Applebottom
Jan 1, 2013

pram posted:

who is discount fishmech

notorious bsd

* # ¿ Jul 30, 2014 01:47
  • Quote
Squinty Applebottom
Jan 1, 2013

 sever

* # ¿ Aug 24, 2014 17:59
  • Quote
Adbot
ADBOT LOVES YOU

# ¿ Apr 28, 2024 12:48
  • Quote
Squinty Applebottom
Jan 1, 2013

echinopsis posted:

im talking about bringing 10 second compiles down to 8 to speed up my work flow

lol you're a hippie burnout in nz what workflow do you have

* # ¿ Sep 2, 2014 12:49
  • Quote
  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply
The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > thread for when you have computer problems