Reputation
309
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 14
Newest
 Constituent
Impact
~9k people reached

  • 0 posts edited
  • 0 helpful flags
  • 30 votes cast
Aug
26
comment Page Life Expectancy Wildly Fluctuating
Last night I bumped the memory from 28GB (the original amount) to 40GB, leaving 8GB of memory for the OS and other processes. Immediately afterward everything returned to normal and has stayed stable. One of our DBAs speculated that SQL Server was confused about how much memory it really had available. I had checked the Total Server Memory both before and after and the numbers were consistent with I see in Server Properties but I find that assertion difficult to argue against.
Aug
25
comment Page Life Expectancy Wildly Fluctuating
Thanks @Shanky! Our Read and Write latency is generally under 20ms. For determining the disks I/O saturation, which counters should I be reviewing?
Aug
25
asked Page Life Expectancy Wildly Fluctuating
Aug
11
awarded  Constituent
Aug
11
accepted Permissions To Update Legacy DTS Packages
Aug
11
answered Permissions To Update Legacy DTS Packages
Aug
11
awarded  Caucus
Aug
5
awarded  Tumbleweed
Jul
29
asked Permissions To Update Legacy DTS Packages
Jul
21
comment Linked Server Query Failures Due To Indexes
Hi Kin. Thank you for the reply. I used sp_MSset_oledb_prop to search our entire enterprise and every provider we have is setup with "Index as access path" = 0. Oddly though, none of the providers have any linked servers associated with them when viewing through Provider Options although we have a fair number of functioning linked servers.
Jul
20
revised Linked Server Query Failures Due To Indexes
deleted 5 characters in body
Jul
20
asked Linked Server Query Failures Due To Indexes
Jul
8
comment Hiding a SQL Server vs Turning Off SQL Browser
@AaronBertrand thanks!!
Jul
8
comment Hiding a SQL Server vs Turning Off SQL Browser
@AaronBertrand, how do you usually setup servers? Do you turn browser off and leave Hide Instance = NO?
Jul
8
comment Hiding a SQL Server vs Turning Off SQL Browser
Thanks to both of you!
Jul
8
comment Hiding a SQL Server vs Turning Off SQL Browser
Thanks much Kin. I do have 3 server instances that are hidden; however, I can reach them via TCP/IP. I can confirm that by connecting to the instance from my local machine or a DSN using "ServerName,1433". Is that being translated on the server to shared memory somehow? I believe that that is true only if you turn off all TCP/IP and Named Pipes.
Jul
8
accepted Hiding a SQL Server vs Turning Off SQL Browser
Jul
8
asked Hiding a SQL Server vs Turning Off SQL Browser
Jun
25
awarded  Popular Question
May
15
awarded  Critic