meta user
network profile
| bio | website | jonseigel.com |
|---|---|---|
| location | London, Canada | |
| age | 29 | |
| visits | member for | 3 years, 6 months |
| seen | yesterday | |
| stats | profile views | 59 |
SQL Server database developer and DBA.
In my spare time, I enjoy juggling, playing guitar, and working out.
Blog: http://voluntarydba.com, @VoluntaryDBA
Business inquiries: jon@jonseigel.com
|
Oct 19 |
answered | How to force a drop of MSSQL Server database |
|
Oct 12 |
awarded | Popular Question |
|
Oct 2 |
comment |
PerfMon counters have different Page File % Usage values for _Total and C:\pagefile.sys for SQL Server on VM Just to verify -- the system page file is actually C:\pagefile.sys? Has the file-specific counter ever been above zero at any time? |
|
Sep 24 |
comment |
Attempt to fetch logical page Is this a reoccurring problem, or did it only happen once? |
|
Sep 24 |
comment |
Can only connect to sql server express 2012 via named pipes Have a look at this answer: stackoverflow.com/a/11853321 |
|
Sep 24 |
comment |
Can't Connect SQL server - process being used by another process. Conflict with IIS? How are you connecting to SQL Server? Are you specifying the file names in the connection string? |
|
Aug 16 |
comment |
MS SQL Server 2000 timeout error with no apparent cause @gsteinert: Applications sometimes don't implement timeout settings correctly (because I've neeeeeever made that mistake myself... lol). Yeah, if you can see the end of it, I'd just as soon let it limp along until it goes away. |
|
Aug 14 |
comment |
SQL Server error: Error: 802, Severity: 17, State: 20 What is the server's maximum memory setting set to? |
|
Aug 14 |
answered | MS SQL Server 2000 timeout error with no apparent cause |
|
Aug 14 |
answered | How to change default recovery for new databases? |
|
Jun 3 |
comment |
Win Server 2008 R2 with Hyper-V and SQL Server @wobblycogs: According to this, the limit for SQL 2008 R2 Standard is 64 GB; according to this (a bit old, but seems reasonable), Hyper-V supports up to 4 cores and 64 GB RAM per VM. |
|
Jun 3 |
comment |
Parallel Processing in SQL Server 2008 R2 What do you need to scale out? Reads? Writes? Both? Reads are far easier to scale out than writes. |
|
Oct 8 |
awarded | Yearling |
|
Aug 15 |
awarded | Excavator |
|
Jul 15 |
answered | High CXPACKET wait type in SQL Server even with MAXDOP = 1 |
|
Jun 23 |
comment |
Database Backup and Full-Text Search Did you try the registry changes? Seems pretty harmless to put it back if the change does nothing. |
|
Apr 9 |
comment |
How to allow users to monitor performance of a set of servers without touching every server? My point about Perfmon is that it requires permissions to be set on each individual box I want to monitor. I will check out the other two products. Thanks. |
|
Apr 5 |
answered | How do Resource Governer changes take effect after being set? |
|
Apr 4 |
comment |
What can cause SQL Server's maximum memory setting to appear to change over time? Yep, this is it. Looks like our memory allocation for SQL Server was a tad aggressive. Thanks! |
|
Apr 4 |
accepted | What can cause SQL Server's maximum memory setting to appear to change over time? |
