Lets first assume $\zeta_i=0$ and ask the following:
- under which conditions $w^*$ is a stable fixed point?
If it's not a stable fixed point for noise-free case, then you won't end up with a fixed mean or stationary distribution after adding additive noise. This means $w^*$ being a fixed point is a necessary condition for ergodicity. In the case of isotropic Gaussian noise, it might also be sufficient (needs checking)
Example
Consider 2-dimensional problem with the following covariance:
\begin{equation}
\Sigma=\left(
\begin{matrix}
1 & 0 \\
0 & 2
\end{matrix}
\right)
\end{equation}
One condition on step size $\eta=\alpha$ which guarantees convergence
$$\frac{2}{\alpha}<\text{Tr}(\Sigma)+2\|\Sigma\|$$
This equation is derived in many places, ie 3.30 in Diniz "Adaptive Filtering". This produces the following condition on step size in our example:
$$\alpha<\frac{2}{7}$$
However, this condition is too strict and larger values of $\alpha$ work. The necessary and sufficient condition turns out to be the following:
$$\alpha<\frac {4} {9 + \sqrt {17}}$$
I extend the expression above for a general Gaussian in this note. I haven't seen anyone else derive this, please correct me if this already occurs in literature.
General solution
For $x_i$ sampled from a zero-centered Gaussian with covariance $\Sigma$, the necessary and sufficient condition for $w^*$ to be a fixed point in a noiseless case is that
$$\alpha<\frac{2}{\rho(A)}$$
Where $\rho$ denotes spectral radius and $A$ is defined below. Let $s=(s_1, s_2, s_3, \ldots)$ be the eigenvalues of $\Sigma$, then
\begin{equation}\label{defa}
A=
2 \left(
\begin{array}{cccc}
s_1 & 0 & 0 & \ldots \\
0 & s_2 & 0 & \ldots \\
0 & 0 & s_3 & \ldots \\
\ldots & \ldots & \ldots & \ldots
\end{array}
\right)
+
\left(
\begin{array}{cccc}
s_1 & s_1 & s_1 & \ldots \\
s_2 & s_2 & s_2 & \ldots \\
s_3 & s_3 & s_3 & \ldots \\
\ldots & \ldots & \ldots & \ldots
\end{array}
\right)
\end{equation}
I haven't found a simpler closed form expression for this, but a sequence of bounds can be derived by bounding spectral radius of $A$ with norm of $A^k$ for various values of $k$, discussion.
I suspect that convergence to fixed point in noiseless case also implies convergence to stationary distribution in the case of isotropic additive noise. In the case of non-isotropic noise, may need to consider the ratio of $\Sigma$ and covariance of noise matrix, like is done in NQM paper
Existing results for non-Gaussian case:
It can be shown that in the case of 1 dimension and deterministic $x$, the following condition on $\alpha$ is necessary and sufficient for convergence
\begin{equation}\label{supersimple}
\alpha x^4 < 2 x^2
\end{equation}
Since we have $h=x^2$ for Hessian $h$, this reduces to the well known bound on convergent learning rate: $\alpha < 2/h$
In the case of stochastic x, the following is necessary and sufficient
\begin{equation}\label{eq:0}
\alpha E[x^4] < 2 E[x^2]
\end{equation}
For the case of $x$ being distributed as standard normal, this gives $2/(3h)$ for the largest learning rate, three times smaller than what's allowed in deterministic case
For the case of $d$ dimensions, the following is a sufficient condition, with $\prec$ indicating Loewner order\footnote{assumption A.6 in Bach paper
\begin{equation}\label{eq:1}
\alpha E[xx'xx'] \prec E[xx']
\end{equation}
The right-hand side can be tightened to
\begin{equation}\label{eq:1x}
\alpha E[xx'xx'] \prec 2 E[xx']
\end{equation}
Bach, Deffosez2015 showed that the following optimization over symmetric matrices gives sufficient condition for convergence, and conjectured it to also be necessary (Lemma 1 of Defossez2015)
\begin{equation}\label{eq:2}
\frac{1}{\alpha} < \sup_{A\in \mathcal{S}(R^d)} \frac{E[(x'Ax)^2]}{2 E[x'A^2 x] }
\end{equation}
We can show this to be equivalent to the following positive semi-definite constraint
\begin{equation}\label{eq:3}
\alpha E[xx' \otimes xx'] \prec E[xx'\otimes I] + E[I\otimes xx']
\end{equation}
Most recently, Jain generalized last Eq to batch sizes beyond 1 and formally showed it to be a necessary condition for monotonic convergence. When applied to Gaussian case, this is equivalent to $\text{Tr}(\Sigma)+2\|H\|$ condition derived earlier.